Hi
I am deleteing records in Oracle table and writing to a sequential file.
Using Datastage - OCI - Transformer - Seq File
As I understand Datastage does implict commit on INSERT, DELETE, UPDATE.
Is there a way to prevent implict commit?
Ketfos
Commit on Delete/Insert/UPdate
Moderators: chulett, rschirm, roy
There's no way to not commit your work. You do, however, have control over the commit level using the Transaction Handling tab on the OCI stage via the Rows Per Transaction setting. Default is 0 which means only after all rows have been worked successfully and the stage closes the connection.
That being said, how are you accomplishing the deletes in your posted design - before sql?
That being said, how are you accomplishing the deletes in your posted design - before sql?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi,
I am using a simple sql in input OCI stage
(Select name, address from customer where customer name like 'K%' )
In the Output OCI stage, I Update the customer table with
Udpdate Action - Delete existing row only
SQL shown is - Delete from Customer where customer name:=1
Also I write the deleted records to a Sequential file.
Ketfos
I am using a simple sql in input OCI stage
(Select name, address from customer where customer name like 'K%' )
In the Output OCI stage, I Update the customer table with
Udpdate Action - Delete existing row only
SQL shown is - Delete from Customer where customer name:=1
Also I write the deleted records to a Sequential file.
Ketfos