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

What is difference between user and database in teradata?

616


Which is faster fastload or multiload?

593


What is meant by a Highest Cost Plan?

619


Highlight a few of the advantages that ETL tools have over Teradata.

609


How would you load a very large file in teradata in general? What utility would you use for it? Why?

593






How do you define Teradata?

605


What is the opening step in basic teradata query script?

592


Highlight the differences between Primary Key and Primary Index.

612


What type of indexing mechanism do we need to use for a typical data warehouse?

614


Explain the most common data types used in teradata?

586


What are the different design perspectives used in teradata?

548


What is a three-tier data warehouse?

626


What is the difference between global temporary tables and volatile temporary tables?

634


How do you do backup and recovery in teradata?

545


What do you mean by parsing?

629