to change commit level
Posted: Sat Aug 14, 2010 7:29 am
hi..,
I am new to datastage... please help me in this issue..
I am using ODBC enterprise stage in job. job is very simple, direct mapping from source to target...
Source is having 10,000 rows, if the job gets aborted after 5950 rows. the rows are getting committed in the target.
my need is
it should not commit in the target, so if i run the job again it should start from first row.
or
if i run the job again it should start from 5951 th row.
is there any option to set in ODBC stage or any other stage will help my need full...
I am new to datastage... please help me in this issue..
I am using ODBC enterprise stage in job. job is very simple, direct mapping from source to target...
Source is having 10,000 rows, if the job gets aborted after 5950 rows. the rows are getting committed in the target.
my need is
it should not commit in the target, so if i run the job again it should start from first row.
or
if i run the job again it should start from 5951 th row.
is there any option to set in ODBC stage or any other stage will help my need full...