Where is the oracle row commit defined in DataStage? Administrator? If yes, which variable?
As a default, how many rows are committed by the Oracle Stage in DataStage in an Oracle table? Is it something we can control or change in DataStage to increase the number of commit in a particular interval?
hi andrw: i want to update some columns in a table and if the job aborts in the middle i dont want to commit anything, i want want to leave as it is as before the job started. Only if job runs successfully i want to commit. Where can i set this in the datastage.
hi andrw: i want to update some columns in a table and if the job aborts in the middle i dont want to commit anything, i want want to leave as it is as before the job started. Only if job runs successfully i want to commit. Where can i set this in the datastage.
hi andrw: i want to update some columns in a table and if the job aborts in the middle i dont want to commit anything, i want want to leave as it is as before the job started. Only if job runs successfully i want to commit. Where can i set this in the datastage.
it will be better to find out why the job was failed and solve that.
why you don't want commit interval, if the job abort don't you will restart the job?
if there are large number of records for update and insert then you may possibly hit the rollback segment error.