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
There is a LIBNAME Statement Option so put in your statement AUTOCOMMIT=NO.
For mre details see
You can set it on the LIBNAME statment if you are using CONNECT USING.
Otherwise try it in an EXECUTE block.
Not tested...
There is a LIBNAME Statement Option so put in your statement AUTOCOMMIT=NO.
For mre details see
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: