Archives of the TeradataForum

Message Posted: Fri, 29 Mar 2013 @ 09:56:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All,

I am executing queries as below in my BTEQ script.

I am using TD mode, not ANSI.

     BT;

     Request#1 - insert
     .IF ERRORCODE <> 0 THEN .EXIT ERRORCODE;

     Request#2 - insert
     .IF ERRORCODE <> 0 THEN .EXIT ERRORCODE;

     Request#3 - insert
     .IF ERRORCODE <> 0 THEN .EXIT ERRORCODE;

     Request#4 - update
     .IF ERRORCODE <> 0 THEN .EXIT ERRORCODE;

     Request#5 - delete
     .IF ERRORCODE <> 0 THEN .EXIT ERRORCODE;

     Request#6 - select (validation)
     .IF ERRORCODE <> 0 THEN .EXIT ERRORCODE; .IF ACTIVITYCOUNT <> 0 THEN .EXIT 8;

     Request#7 - select (validation)
     .IF ERRORCODE <> 0 THEN .EXIT ERRORCODE; .IF ACTIVITYCOUNT <> 0 THEN .EXIT 8;

     ET;

What we are expecting is that, when validation got failed, all above insert, update and delete should get rollback.

I have tried with small table and it work fine.

But in actual, when insert happens in 100 Million to 1 Billion range, the changes are still reflected in the tables even validations are failed and job got abended.

Kindly let me know your suggestion.

Thanks in advance,

Sughesh I S.

	<Prev	Next>		<<First	<Prev	Next>	Last>>