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
Explain the teradata primary index mechanics in detail with a diagram.
If RDBMS is halted what will you do ?
What are the functions of a teradata dba?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What does sleep function does in fast load?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What is the difference between fastload and multiload? Which one is faster?
Differentiate database data and data warehouse data?
How many tables can you join in v2r5?
What are default access rights in teradata? What explicit right can be given to a user?
What are the different methods ot loading a dimension table? A fact table etc?
What are the various indexes in teradata? Why are they preferred?
What is difference between user and database in teradata?
What are default access rights in teradata?
Explain the term 'row' related to relational database management system?