What is differnce between Error code and Error Level in Bteq
- 6 Answers
- 36802 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to find duplicates in a table?
What is a level of granularity of a fact table?
Can we collect statistics on multiple columns?
Describe primary index in teradata. And what are the available primary index types?
What is a three-tier data warehouse?
Comment whether bottleneck is an error or not.
What are the steps involved in the process flow of the sql statement through channel attached system?
What are the available primary index types?
What is the use of virtual processor connectivity in teradata?
what are the day to day activities of teradata DBA ?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Explain parsing engine in teradata?
How can we check the version of Teradata that we are using currently?
Explain teradata utilities?
