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 command in bteq to check for session settings ?

632


How to Extract data from multiple legacy systems?

572


What is the basic syntax for teradata select statement?

572


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2342


Can you connect multiload from ab initio?

640






What is the difference between teradata and basic rdbms?

564


What is meant by a Clique?

585


What are some commonly used bteq scripts?

563


What are the functions performed by bynet?

603


What is meant by Teradata Gateway?

580


How many sessions of MAX is PE capable of handling at a particular time?

587


What are the different functions performed in development phase?

568


Which is more efficient group by or distinct to find duplicates?

637


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

1956


Difference between multiload and tpump?

617