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 is multi insert?
What do you mean by ttu in teradata?
What is meant by a node?
What are the available primary index types?
What are the various indexes in teradata?
What are the frequently used data types in teradata?
How to load specific no.of records using bteq, or fastload,or multiload
Difference between star and snowflake schemas?
What are aggregate tables? How do you design them using teradata?
What is inner join and outer join?
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?
What is stored procedure in teradata?
When tpump is used instead of multiload?
List out teradata data types?
What is the primary index in teradata?