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.
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.
