The BTEQ server is returning some error message as error code 3534

Asked By Jerry Blando 50 points N/A Posted on - 10/29/2012

Hello,

As a BTEQ user I am having some problems in handling teradata database. The BTEQ server is returning some error message as error code 3534. I asked few questions for solutions in the forum but found no result. Can you provide me some suggestion for this handling error?

Thanks.

• Status: Open
• Question Views: 927
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Software Others

Answered By John Moores 0 points N/A #145433

The BTEQ server is returning some error message as error code 3534

Hello…

While handling errors in Teradata, BTEQ also provides a
“return code value” in an attribute, it is called “ERRORLEVEL”   which
can be used to take necessary action depending on the return error code.

For any database error message BETQ gives the code CLI0530.

Also you can change the severity level of an error code,

.SET ERRORLEVEL 2163

.SEVERITY 3(2134,3342,3424)

.SEVERITY  8

.SET ERRORLEVEL UNKNOWN SEVERITY 13BTEQ
error level severity doesn’t make any strong impact to the operations,
unless error checking is incorporated in the work sheets.

The ERRORLEVEL attribute set the threshold value.

Set the MAXERROR as “.SET MAXERROR 12”, then any error occurs for which the
return code is larger than the “MAXERROR”, error scripts will vanish.

About John Moores

Questions
3

Answers
29

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 11/14/2012
• Question Category: Software Others