undo changes
Posted: Thu Sep 08, 2005 2:42 am
Hi!
I am using transformer to divide one input strem into four outputs.
Order of my output links is as following:
1 output writes data to hashfile1
2 output inserts data into database table1
3 output updates data into database table1
4 output modifies data in hashfile1
I want that any changes in database table and in hashfile were made only if every four outputs links don't return any errors.
Another option is to undo any erlier changes (made in database and in hashfile) made by erlier links , if error occures .
Is there some way to do this in DataStage?
Thanks for help
regards
I am using transformer to divide one input strem into four outputs.
Order of my output links is as following:
1 output writes data to hashfile1
2 output inserts data into database table1
3 output updates data into database table1
4 output modifies data in hashfile1
I want that any changes in database table and in hashfile were made only if every four outputs links don't return any errors.
Another option is to undo any erlier changes (made in database and in hashfile) made by erlier links , if error occures .
Is there some way to do this in DataStage?
Thanks for help
regards