Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What is differnce between Error code and Error Level in Bteq

Answers were Sorted based on User's Feedback



What is differnce between Error code and Error Level in Bteq..

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

What is differnce between Error code and Error Level in Bteq..

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

What is differnce between Error code and Error Level in Bteq..

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

What is differnce between Error code and Error Level in Bteq..

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

What is differnce between Error code and Error Level in Bteq..

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

What is differnce between Error code and Error Level in Bteq..

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

Post New Answer

More Teradata Interview Questions

write lock is compatiable with which type of lock?

6 Answers   Infosys,


Explain BYNET.

0 Answers  


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

0 Answers  


How to load specific no.of records using bteq, or fastload,or multiload

0 Answers   Infosys,


plz explain parlla distribution and subtable concept in teradata

3 Answers   TCS,


Does SDLC changes when you use Teradata instead of Oracle?

2 Answers  


How many macros we can create inside a macro

1 Answers   Wipro,


Is multi insert ansi standard?

0 Answers  


what are the uses of fact table and dimension table in banking project?

0 Answers   TCS,


When tpump is used instead of multiload?

0 Answers  


i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me

8 Answers   Satyam,


TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)

2 Answers   TCS,


Categories