Hi All,
I assigned library name for SQL DB as shown below:
Libname SQLDB ORACLE user=ABCD pass=1234 Path="SCHEMA_123" insertbuff=50000 dbcommit=50000 schema=1234
If i run any SQL part of code to create table in that library, connectivity is getting diconnected. so abnormal termination happens with limited observation.
so i removed insertbuff=50000 and processed,
Libname SQLDB ORACLE user=ABCD pass=1234 Path="SCHEMA_123" dbcommit=50000 schema=1234
now connectivity is good but computation time is more than a day its taking to create table.
Please suggest to compute efficiently.
Thanks,
Ganesh K
May be try a lower value for insertbuff to figure out the optimal value for your site.
From the documentation:
Please post the SQL code you are using to create the Oracle table and tell us how many rows of data you are loading. If your row count is large then you may want to consider bulk loading:
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.