Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


Subj:   Re: Why BT-ET not working on large volume of data?
 
From:   sughesh iyyani

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020