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

Explain the teradata primary index mechanics in detail with a diagram.

571


What is the purpose of upsert command?

595


Explain how spool space is used.

621


What is meant by a Channel Driver?

649


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

656






What does Amp contain and what are all the operations that it performs?

591


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

639


What are the available primary index types in teradata.

589


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

711


What is the use of having index on table?

584


What are default access rights in teradata?

629


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

590


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

572


What are differences between teradata and ansi session modes in teradata?

630


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

1607