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 the difference between union and union all in teradata?
What is a dimension table?
What are the various indexes in teradata? Why are they preferred?
any one answer me how they can analyzing the project using data ware housing?
Why does varchar occupy 2 extra bytes?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Differentiate primary key and partition key?
Explain the term 'database' related to relational database management system?
Explain the advantages of partitioned primary index in a query?
What is teradata? Also, list out some of the primary characteristics of teradata.
What is the difference between teradata and oracle?
How to select first n records in teradata?
What are the updated features of teradata?
what is sysdba and sysdbc ? which has high priority ?
What is meant by a Parsing Engine?