Hi, While submitting request as BT;stmt 1;stmt 2;stmt 3;ET; in Teradata SQL ASSISTANT and Unix has different behaiour, in SQL ASSISTANT after failure of one statement transaction rollsback but in UNIX it is taking all three statements as individual statemets (why not as one transaction). Someone help. thx
Not sure what you mean by "in Unix". Do you mean "in BTEQ?"
By default SQL Assistant stops executing SQL when an error is encountered.
In BTEQ you must explicitly check - using .IF after each statement and/or .SET MAXERROR - to exit the script on failure.
Or use "leading semicolon" syntax to have BTEQ submit a multi-statement request: