Archives of the TeradataForum
Message Posted: Sun, 12 Sep 2004 @ 16:18:20 GMT
| 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
The PPRTEXT call just formats explanatory text corresponding to the code.