How do I set the Oracle commit level in Proc SQL/Access for Oracle (ex...

DougZ · Posted 04-04-2022 05:24 PM

Running on RH Linux 3.10.0-1160.53.1.el7.x86_64 (LIN X64),

SAS 9.4 (TS1M6)

SASKiwi · Posted 04-04-2022 05:37 PM

Not sure what you mean by Oracle commit level. Search Oracle forums for the required Oracle command you want to run - not really a SAS question. These will work in the SAS EXECUTE statement in SQL Passthru. If you mean setting the number of rows to be included in an Oracle COMMIT, then the SAS option DBCOMMIT can do that.

How do I set the Oracle commit level in Proc SQL/Access for Oracle (execute statement) for loading?

Re: How do I set the Oracle commit level in Proc SQL/Access for Oracle (execute statement) for loadi

How do I set the Oracle commit level in Proc SQL/Access for Oracle (execute statement) for loading?

Re: How do I set the Oracle commit level in Proc SQL/Access for Oracle (execute statement) for loadi

Registration is open

SAS Training: Just a Click Away