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

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.

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.

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.

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.

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

i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table

6 Answers   Satyam,

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

0 Answers  

id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

6 Answers   Cap Gemini,

Hash collision?

3 Answers   Satyam,

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

0 Answers  

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

0 Answers  

Can any one plz provide the teradata interview questions?

10 Answers  

Difference between client character set and server character set? What is the use of these two?default character set in teradata?

1 Answers   TCS,

Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?

2 Answers   IBM,

how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer

2 Answers   IBM,

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

6 Answers   Wipro,

which option is used to restart the fastexport script ?

2 Answers   TCS,