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
How to eliminate product joins in a teradata sql query?
How do you do backup and recovery in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
How is MLOAD Client System restarted after execution?
What are aggregate tables? How do you design them using teradata?
Difference between multiload and tpump?
What does sleep function does in fast load?
Define views in teradata with syntax.
Explain BYNET.
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is the use of fallback?
Discuss the advantages of using partitioned primary index in a query?
How do you define Teradata?
What are the newly developed features of Teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?