Interested to Buy Any Domain ? << Click Here >> for more details...
What is differnce between Error code and Error Level in Bteq
- 6 Answers
- 39039 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 |
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
How do you set the session mode parameters in bteq?
If the script is aborted. why it is aborted and how can you identify ?
What do you mean by teradata intelliflex?
What does sleep function does in fast load?
Write a program to show the parser component used in teradata?
Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?
Why do Hash joins usually perform better than Merge Joins?
List the logical and conditional operators that are used with teradata along with their meanings?
What is a pseudo key? What is its use???
What is the difference between global temporary tables and volatile temporary tables?
What are the commands to make a new table, change a table and remove a table in teradata?
Teradata 
