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

What does sleep function does in fast load?

865


What is meant by a Highest Cost Plan?

842


What are the various indexes in teradata? How to use them? Why are they preferred?

856


How to Extract data from multiple legacy systems?

834


Explain the term 'primary key' related to relational database management system?

842


What are the various indexes in teradata?

806


What is the use of teradata system software?

807


What are the advantages of teradata?

817


how can we analyze the locks ?

1899


What do you mean by fastexport in teradata?

776


Why is the case expression used in teradata?

829


What is the difference between fastload and multiload?

1045


Explain the types of join supports by teradata?

794


Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

862


Can we collect statistics on table level?

821