Interested to Buy Any Domain ? << Click Here >> for more details...
What is differnce between Error code and Error Level in Bteq
- 6 Answers
- 39358 Views
- IBM, I also Faced
- E-Mail Answers
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
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is the purpose of indexes?
How would you load a very large file in teradata in general?
What are normalization, first normal form, second normal form and third normal form?
What do high confidence, low confidence and no confidence mean in explain plan?
What type of indexing mechanism do we need to use for a typical data warehouse?
What is smp and mpp platforms?
What's the difference between timestamp (0) and timestamp (6)?
If a Node is busy what are the steps you can take to avoid ?
Why are oltp database designs not generally a good idea for a data warehouse?
Steps to create a data model?
Highlight the limitations of TPUMP Utility.
What can be achieved by using the teradata rdbms?
Can we collect statistics on multiple columns?
How do you verify a complicated sql?
