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
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.
Ready to level-up your skills? Choose your own adventure.