Roll Back in ODBC
Moderators: chulett, rschirm, roy
Roll Back in ODBC
Hi All,,
I am loading data from Db2 to SQL Server and for SQL Server I am ODBC stage.
I want to roll back the rows if the job gets aborted in the middle.
Is there any way we can do that in Parallel in ODBC stage?? Or any other approach?
Please Advice.
Thanks & Regards,
Kumar66.
I am loading data from Db2 to SQL Server and for SQL Server I am ODBC stage.
I want to roll back the rows if the job gets aborted in the middle.
Is there any way we can do that in Parallel in ODBC stage?? Or any other approach?
Please Advice.
Thanks & Regards,
Kumar66.
Hi Chulett,
Is there any other approach or design that can be done.
I have given Method = Write and Mode =Append.
When ever my job fails , it should not load the data already loaded.
For e,g if my source has 10 records and my job aborted at 6 record , If i am running my job it should load from the 7 th record.
Please Advice.
Thanks & Regards,
Kumar66.
Is there any other approach or design that can be done.
I have given Method = Write and Mode =Append.
When ever my job fails , it should not load the data already loaded.
For e,g if my source has 10 records and my job aborted at 6 record , If i am running my job it should load from the 7 th record.
Please Advice.
Thanks & Regards,
Kumar66.
there are some confusions.
I don' know how 'Append' mode is checking for the previous data that was inserted.It shouldn't do this unless there is a unique constraint on that specific column.Use 'truncate' in that place.
Ideally in datastage if the job aborts the rows should be rolled back.but it is inconsistent(might be due to some specific patch).in that case u have to manually truncate the table.
p.s. use odbc enterprise stage.
I don' know how 'Append' mode is checking for the previous data that was inserted.It shouldn't do this unless there is a unique constraint on that specific column.Use 'truncate' in that place.
Ideally in datastage if the job aborts the rows should be rolled back.but it is inconsistent(might be due to some specific patch).in that case u have to manually truncate the table.
p.s. use odbc enterprise stage.
Probal