What is differnce between Error code and Error Level in Bteq

Answer Posted / tdguy

Errorcode is used in bteq conditional logic. It holds the
return code of every sql in bteq. 0 indicates perfect
excution of the sql.

Errorlevel assigns severity to error numbers.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between stored procedure and macro?

787


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

701


What is the use of stored procedures in teradata?

659


List out all forms of LOCKS that are available in Teradata.

646


What are the different functions included in the server software?

681






What is smp and mpp platforms?

612


How do you do backup and recovery in teradata?

645


What are the available primary index types?

804


What is the basic syntax for teradata select statement?

669


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

737


Explain the new features of teradata?

677


What is meant by a Least Cost Plan?

704


How do you see a ddl for an existing table?

667


What are the frequently used data types in teradata?

670


any one answer me how they can analyzing the project using data ware housing?

2108