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 a clique?

585


What are the commands to make a new table, change a table and remove a table in teradata?

615


Why do you get spool space errors? How do trouble-shoot them?

596


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

684


What are the various etl tools in the market?

587






Highlight a few of the important components of Teradata?

586


What are the functions involved in shared information architecture?

606


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

601


List the logical and conditional operators that are used with teradata along with their meanings?

554


how many modules are there in telecome domain?how to explain the architecture?

1559


What are the components used in smp and massively parallel processing (mpp) machines?

603


What are the string manipulation operators and functions associated with teradata?

639


There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

645


Explain Teradata performance tuning and optimization?

703


What are the advantages of teradata?

603