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
What are the main components of teradata system?
What is the use of teradata system software?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Explain the teradata primary index mechanics in detail with a diagram.
How to run a query in teradata?
Describe primary index in teradata?
What are differences between teradata and ansi session modes in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is difference between user and database in teradata?
What is meant by a node?
What are normalization, first normal form, second normal form and third normal form?
Write a program to show the parser component used in teradata?
What are the available join types in teradata?
Where is teradata rdbms used?
What do you mean by tpt in teradata?