What is differnce between Error code and Error Level in Bteq
Answer Posted / uli
in addiion to the above
Error-Coce is set with each SQL-statement
Error-level is kept for the whole Session
So, it makes a difference in conditinals
.if ERRORCODE -- question about the last statement
.if ERRORLEVEL -- question about the highest level reached
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In general, how do you optimze any sql in teradata?
Describe the between keyword in teradata?
What is the difference between teradata and oracle?
In BTEQ, how are the session-mode parameters being set?
Highlight the limitations of TPUMP Utility.
Explain the term 'columns' related to relational database management system?
What can be achieved by using the teradata rdbms?
What are the different methods ot loading a dimension table? A fact table etc?
Steps to create a data model?
What is the difference between fastload and multiload? Which one is faster?
Explain the term 'database' related to relational database management system?
When tpump is used instead of multiload?
How many types of joins are there in teradata?
What are the 5 phases in a multiload utility?
What do you mean by teradata intelliflex?