Transaction Grouping across multiple ODBC Stages

[josephwu]

From the datastage documentation, I can define a transaction grouping for multiple links from a single Transform Stage to a single ODBC Stage. I would like to know if I can define a transaction grouping from a single Transform Stage to multiple ODBC Stages (all within the same database but different tables).

There is a requirement to read from a single source record and output several records to different tables in the same database as a single unit of work. That is in case there is an error inserting a record to one of the tables, all the records inserted need to be rollback and continue to process the next source record.

Any suggestions??? THANKS...

[chulett]

You can (and must) use a single ODBC stage. The only time you would need to use multiple stages is if the target tables are in different databases.

Each link can point to a different table, the only 'restriction' when using a single stage is they all must reside in the same database / instance and be accessable to the same user.

[josephwu]

Thanks. Didn't notice the Input Name drop down box which can be used to defined different tables for each link in a single ODBC stage.

Thanks again for the quick reply.