Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 12 Sep 2004 @ 16:18:20 GMT


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


Subj:   Re: PP2-Teradata Mask SQL errors in batch
 
From:   Fred Pluebell

This is standard behavior and is in no way unique to Teradata PP2.

It's not a question of "masking" anything. The SQL call returns status to its caller. It's up to you to check that status, and the program logic will determine what happens next. For example, you could choose to accept it and continue, pass back a nonzero value in the RETURN-CODE special register for the step Condition Code (could be the actual SQL error code or just a severity indicator like 8 or 12), or immediately ABEND (abort).

The PPRTEXT call just formats explanatory text corresponding to the code.



     
  <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: 23 Jun 2019