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 are the functions performed by bynet?

825


How do you verify a complicated sql?

863


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?

929


How do you define Teradata?

846


Can you fastexport a field, which is primary key by putting equality on that key?

984


What is a level of granularity of a fact table?

859


Explain teradata architecture in detail with a diagram.

867


Explain teradata vs. Redshift?

795


What are the frequently used data types in teradata?

826


What are the steps involved in the process flow of the sql statement through channel attached system?

895


What are the 5 phases in a multiload utility?

834


What are the advantages of teradata?

817


What is the use of stored procedures in teradata?

796


What are teradata utilities?

859


Difference between multiload and tpump?

865