Date: Tue, 11 Sep 2007 02:55:47 -0700
Reply-To: "email@example.com" <keybdftj@YAHOO.FR>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "firstname.lastname@example.org" <keybdftj@YAHOO.FR>
Subject: SAS / ACCESS Oracle - How to control COMMIT statement
Content-Type: text/plain; charset="iso-8859-1"
Sorry for my last message: I have done a wrong action, which sent it,
as it was not finished... Please forget it!
I want to update an Oracle database with a SAS data set. The DBA ask
me to code in order to COMMIT at the end of the update transaction...
Is there a better way to do it than load the SAS data to Oracle, an
then do an Oracle update (EXECUTE (...) BY ORACLE; EXECUTE (COMMIT) by
ORACLE for example?
Thanks for your help.