N/APosted on - 10/29/2012
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.
I am getting an error code as like CLI0530 in my BTEQ
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.