Commit Frequency of a Stored Procedure Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ag_ram
Premium Member
Premium Member
Posts: 524
Joined: Wed Feb 28, 2007 3:51 am

Commit Frequency of a Stored Procedure Stage

Post by ag_ram »

Hi ,

I am executing a stored procedure by passing parameters from a dataset file.No COMMIT statements are given in the stored procedure. Intention is to rollback all records processed by this job in case of any failure. I have set the transaction size to '0' . My question is whether COMMIT happens if the job gets completed successfully or do we need to explicitly mention this ?

Please suggest...
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I don't know for certain off the top of my head, but it sure seems like it would be quicker to simply test it yourself than ask here. And then let us know the answer, of course. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply