Interested to Buy Any Domain ? << Click Here >> for more details...
What is differnce between Error code and Error Level in Bteq
- 6 Answers
- 39380 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / yuvaevergreen
Error code or return code is a value returned by BTEQ at
the end of each query. Error level is a bteq command used
to assign severity to some error numbers.
.IF ERRORCODE > 0 THEN .GOTO ... is an example for error
code .SET ERRORLEVEL 3807 SEVERITY 0 is an example.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / raos
Error code returns zero if the previous sql statement is success.t returns non zero value if the previous sql statement is failed.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / vinay sir(datawarehousing tech
One small correction to the above answer.
Errorcode: The code returned by the previous sql statement
which resembles the error message information(we can see in
DBC.ErrorMsgs table).
Return Code: The code return by the script after execution.
These return codes can be 0,2,4,8,12,16.
Note: Error code and Return code are different.
Errorlevel:The severity set to the errorcode at the
time of errorhandling.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
Answer / uli
in addiion to the above
Error-Coce is set with each SQL-statement
Error-level is kept for the whole Session
So, it makes a difference in conditinals
.if ERRORCODE -- question about the last statement
.if ERRORLEVEL -- question about the highest level reached
| Is This Answer Correct ? | 1 Yes | 0 No |
one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?
How to identify ppi columns?
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What is differnce between Error code and Error Level in Bteq
What are the functions of a teradata dba?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Describe the between keyword in teradata?
How to relege locks in fastload and multiload? example?
What do you mean by caching in teradata?
suppose one Cylinder split data blocks are moved from where?
How can you track login parameters of users in teradata?
Teradata 
