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 does sleep function does in fast load?
What is meant by a Highest Cost Plan?
What are the various indexes in teradata? How to use them? Why are they preferred?
How to Extract data from multiple legacy systems?
Explain the term 'primary key' related to relational database management system?
What are the various indexes in teradata?
What is the use of teradata system software?
What are the advantages of teradata?
how can we analyze the locks ?
What do you mean by fastexport in teradata?
Why is the case expression used in teradata?
What is the difference between fastload and multiload?
Explain the types of join supports by teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Can we collect statistics on table level?