Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 18 Jul 2006 @ 19:18:03 GMT


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


Subj:   Re: Capture of BTEQ return code
 
From:   Meade, Cornelius

Here is one way.....As you know there is the ERRORCODE value that can be interpreted to check the exit status of each line in a BTEQ script. If you code:

     .QUIT ERRORCODE

In the BTEQ script, it will terminate the BTEQ session with what ever ERRORCODE value has been set at that point. Depending on your scripting environment, you then simply need to trap the return condition from the execution of BTEQ.....


Cornelius Meade III
EDS - Consulting Services/BI/CRM



     
  <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: 15 Jun 2023