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
How do you set the session mode parameters in bteq?
What are the available join types in teradata?
What is the basic syntax for teradata select statement?
How do you see a ddl for an existing table?
Explain the types of join supports by teradata?
What are the things to be considered while creating secondary index?
Explain some differences between mpp and smp?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What are the primary characteristics of the Teradata.
Explain teradata architecture in detail with a diagram.
What are the various indexes in teradata? How to use them?
Steps to create a data model?
Define views in teradata with general syntax.
Differentiate database data and data warehouse data?
What is stored procedure in teradata?