What is differnce between Error code and Error Level in Bteq

Answer Posted / vinay sir(datawarehousing tech

One small correction to the above answer.

Errorcode: 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.

Note: Error code and Return code are different.

Errorlevel:The severity set to the errorcode at the
time of errorhandling.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the teradata primary index mechanics in detail with a diagram.

753


If RDBMS is halted what will you do ?

1909


What are the functions of a teradata dba?

814


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

850


What does sleep function does in fast load?

841


Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3141


What is the difference between fastload and multiload? Which one is faster?

886


Differentiate database data and data warehouse data?

802


How many tables can you join in v2r5?

820


What are default access rights in teradata? What explicit right can be given to a user?

876


What are the different methods ot loading a dimension table? A fact table etc?

806


What are the various indexes in teradata? Why are they preferred?

757


What is difference between user and database in teradata?

848


What are default access rights in teradata?

848


Explain the term 'row' related to relational database management system?

728