Interview Questions   Tutorials   Discussions   Programs   

Teradata - What is difference between Error code and Error Level in Bteq ?




2938
views
asked mar September 20, 2014 06:38 AM  

What is difference between Error code and Error Level in Bteq ?


           

1 Answers



 
answered By vishnoiprem   0  
Errorcode is used in bteq conditional logic. It holds the return code of every sql in bteq. 0 indicates perfect execution of the sql.

The code returned by the previous sql statement which resembles the error message information(we can see in

DBC.ErrorMsgs table).
Return Code: The code return by the script after execution.
These return codes can be 0,2,4,8,12,16.

Errorlevel assigns severity to error numbers.
To know the error codes type
select * from dbc.errormsgs in the Queryman
Error level is the severity set for the corresponding error code
if error level is
0- Success
4- Warning
8- User Error
12- Fatal error
16- Typical Error
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert