What is differnce between Error code and Error Level in Bteq

Answer Posted / harsha

Error code is the code for the error for ex 3807 is the error code for the error "object does not exist"
To know the error codes type
select * from dbc.errormsgs
in the Queryman
Error level is the severity set for the corresponding error code
if error level is
0- Success
4- Warning
8- User Error
12- Fatal error
16- Typical Error

Is This Answer Correct ?    17 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List out teradata data types?

767


What exactly do you know about catching in teradata?

820


What is the purpose of joins in teradata?

800


How to view every column and the columns contained in indexes in teradata?

814


What are the multiload utility limitations?

805


What is the difference between fastload and multiload? Which one is faster?

895


How to Extract data from multiple legacy systems?

824


Explain BYNET.

787


What is a dimension table?

825


What are the different methods ot loading a dimension table? A fact table etc?

816


What is the syntax for case when statement?

825


What are the frequently used data types in teradata?

815


Mention a few of the ETL tools that come under Teradata.

866


Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

790


What is meant by a Clique?

817