topic Re: SAS to Oracle DB connectivity issue in SAS Programming

SAS to Oracle DB connectivity issue

Ganeshk — Tue, 11 Oct 2016 02:30:56 GMT

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

Re: SAS to Oracle DB connectivity issue

Patrick — Tue, 11 Oct 2016 04:54:40 GMT

May be try a lower value for insertbuff to figure out the optimal value for your site.

From the documentation:

http://support.sas.com/documentation/cdl/en/acreldb/69039/HTML/default/viewer.htm#p06u7eb5ienq5in1wq9injrz8vh5.htm

Re: SAS to Oracle DB connectivity issue

SASKiwi — Tue, 11 Oct 2016 07:19:30 GMT

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:

http://support.sas.com/documentation/cdl/en/acreldb/69039/HTML/default/viewer.htm#p0ewb0agff5a1vn1mq7lox50dtwh.htm