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


Please Help Members By Posting Answers For Below Questions

Can you connect multiload from ab initio?

640


how do you manage the production space. what are the proactive methods you can take ?

1473


What is the use of having index on table?

581


What are the steps involved after the disk manager passes the request?

576


What is logical data model?

636






What is upsert statement in teradata?

609


Explain the new features of teradata?

564


If a Node is busy what are the steps you can take to avoid ?

1870


While creating table my dba has fallback or no fallback in his ddl. What is that?

684


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

3903


What is meant by a Virtual Disk?

572


What is the purpose of indexes?

584


What is a clique?

581


Why are oltp database designs not generally a good idea for a data warehouse?

591


What is the command in bteq to check for session settings ?

632