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 called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is collect statistics?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is meant by a Virtual Disk?
Define views in teradata with syntax.
What is meant by a Channel Driver?
What is the difference between fastload and multiload?
Which is faster fastload or multiload?
How can we check the version of Teradata that we are using currently?
What are the various indexes in teradata? How to use them? Why are they preferred?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
How do you determine the number of sessions?
Explain the term 'columns' related to relational database management system?