topic Re: PROC SQL PASS-THROUGH in SAS Procedures

PROC SQL PASS-THROUGH

barlocaroni — Tue, 17 Nov 2020 10:03:49 GMT

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 — Tue, 17 Nov 2020 15:55:05 GMT

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

Otherwise try it in an EXECUTE block.

Not tested...

LucaCampa74 — Mon, 23 Nov 2020 11:50:36 GMT

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

For mre details see