Error Handling in BTEQ Teradata?BTEQ Return Codes:Bteq return codes are the two digit values that BTEQ returns to the client operating system as a result of any error code occured in BTEQ session. Possible BTEQ return codes are as given belowReturn Code Description00 Job completed with no errors.02 User alert to log on to the Teradata Database.04 Warning error.08 User error.12 Severe internal errorThe return code is decided by the Error messages that BTEQ receives from the Teradata database. Different Teradata database error codes are assigned a specific return code value.The below table will give what different return codes are returned by BTEQ for different Error codes it receives from Teradata database.For an Example : If you issue a SQL statement in BTEQ session to create a table...

Posted in:
ACTIVITY COUNT,
blogger,
blogging,
blogspot,
ERROR HANDLING,
ERRORCODE=0,
How to,
SQL,
TERADATA,
TERADATA SQL,
we-love-to-share.blogspot.com