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
What is called partitioned primary index (ppi)?
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 ?
Describe primary index in teradata. And what are the available primary index types?
What is meant by a node?
how can we analyze the locks ?
What are the commands to make a new table, change a table and remove a table in teradata?
What are some commonly used bteq scripts?
What are the components provided on node?
What is a level of granularity of a fact table?
How can we check the version of Teradata that we are using currently?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What are the uses of client software involved in teradata?
What is the difference between teradata and basic rdbms?
Highlight the limitations of TPUMP Utility.
Explain the term 'foreign key' related to relational database management system?