Teradata Bteq

Tools & Utilities

Teradata Bteq

Hello all, I am seeking a solution to a possible problem later on. I have a process that simply loads data into a teradata table using bteq. My OS is VM/CMS. On the mainframe platform we use an exec that calls the bteq engine and a cntl file which has the DDL. I would like to test for success or failure of this routine after it is completed. Please advise. If the process is aborted, I would like to rollback any changes that have been made to the database. Obviously some conditional logic is required. Please advise Im a newbee.

Thanks very much,

L