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 is the difference between union and union all in teradata?

628


What is a dimension table?

614


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

567


any one answer me how they can analyzing the project using data ware housing?

2032


Why does varchar occupy 2 extra bytes?

617






Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

574


Differentiate primary key and partition key?

588


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

579


Explain the advantages of partitioned primary index in a query?

572


What is teradata? Also, list out some of the primary characteristics of teradata.

587


What is the difference between teradata and oracle?

560


How to select first n records in teradata?

613


What are the updated features of teradata?

586


what is sysdba and sysdbc ? which has high priority ?

3376


What is meant by a Parsing Engine?

711