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 called partitioned primary index (ppi)?

573


A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

697


What do you mean by fastexport in teradata?

567


How do you see a ddl for an existing table?

583


Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

1615






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

647


What is difference between user and database in teradata?

624


What are the joins in teradata and how many types of joins are there in teradata?

585


What is bteq script in teradata?

645


Explain the new features of teradata?

580


Different phases of multiload?

600


What is the use of fallback?

567


What is a level of granularity of a fact table?

651


why use references rather than pointers in the public api, particularly for arguments which are modified?

566


Highlight the differences between Primary Key and Primary Index.

630