PROC SQL PASS-THROUGH

[barlocaroni]

Hi everyone,
... a small question about PROC SQL pass-through to Oracle.

Is there an option to turn off the AUTOCOMMIT? and where should I put it? on the libname definition, on the dataset name, on the connection string?

Tks a lot

Carlo

[LinusH]

You can set it on the LIBNAME statment if you are using CONNECT USING.

Otherwise try it in an EXECUTE block.

Not tested...

[LucaCampa74 · Accepted solution]

There is a LIBNAME Statement Option so put in your statement AUTOCOMMIT=NO.

For mre details see 

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=acreldb&docsetTarget=p174...