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
Explain the term 'tables' related to relational database management system?
Highlight the advantages of PPI(Partition Primary Index).
Explain PDE.
What are the steps involved after the disk manager passes the request?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are the components provided on node?
What are the string manipulation operators and functions associated with teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
If RDBMS is halted what will you do ?
What is the syntax for case when statement?
What is teradata?
What is multi insert?
What is the command in bteq to check for session settings ?
How many codd's rules are satisfied by teradata database?
What is meant by a node?