I am getting an error code as like CLI0530 in my BTEQ

Asked By ingridgonzalou 30 points N/A Posted on - 10/29/2012

Hi People,

I am getting an error code as like CLI0530 in my BTEQ network while working with teradata. Because of this error code I think more exchange of codes is going on. I have looked in the web forums for some solutions but I didn’t found any solution.

Now I badly need your help to solve this problem.

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

• Answer Accepted: No
• Question Category: Software Others

Answered By John Moores 0 points N/A #143214

I am getting an error code as like CLI0530 in my BTEQ

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 13

BTEQ 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”, scripts vanish.

About John Moores

Questions
3

Answers
29

Best Answers
6

• Vote Up 0 Vote Down

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