I've been connecting to and using data from an Oracle database using a libname statement.
LIBNAME DB_CON ORACLE PATH="&DB_CONNECTION" SCHEMA='MY_SCHEMA' USER=MY_USER PASS="&dbpass";
I've recently started having problems updating rows. I found what I think is the fix here: http://support.sas.com/kb/37/470.html.
It suggests that I need to apply the libname option update_lock_type=row.
I've done this but am seeing something that I don't understand in the SAS log. Next to the new option there is an X. What does this X signify? I do not remember seeing an X in any SAS log before now except when using the X command line statement.
126
127 LIBNAME DB_CON
128 ORACLE PATH="&DB_CONNECTION"
NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks.
129 SCHEMA='MY_SCHEMA'
130 USER=MY_USER
131 PASS="&dbpass"
132 X update_lock_type=row;
NOTE: Libref DB_CON was successfully assigned as follows:
Engine: ORACLE
Physical Name: (DESCRIPTION_LIST= (LOAD_BALANCE=off) (FAILOVER=on) (DESCRIPTION= (CONNECT_TIMEOUT=5)
(TRANSPORT_CONNECT_TIMEOUT=3) (RETRY_COUNT=3) (ADDRESS_LIST= (LOAD_BALANCE=ON)
(ADDRESS= (PROTOCOL=TCP) (HOST= my_host) (PORT=1521)
) )
it looks like no one knows, by people would probably be interested in the answer. Did you contact tech support?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.