handle TASM 3156 error code in Stored Procedure

UDA

handle TASM 3156 error code in Stored Procedure

Hi,

We use TASM to limit duration and spool of some Requests.

We would like to set a continue handler for 3156 Code (coming from TASM when request limit is exceeded) but we are not able to make it work. It works for others errors not coming from TASM.

Do you have an Idea on this subject ?

Thanks a lot

Best Regards

Please find below an extract of our procedure which the 2 handlers set and the sql request with issue ( We put T3156 as indicated in SQL Stored Procedures and Embedded SQL pdf : "For any return codes not listed in this table, Teradata Database sets SQLSTATE to a character

string in the format of the literal character T (LATIN CAPITAL LETTER T) followed by the 4-

digit return code in the Success, Failure or Error parcels."

---- Extract of Stored Procedure

 

DECLARE CONTINUE HANDLER FOR SQLSTATE 'T3156'

INSERT INTO BD_OTV_DATA_PPR03.WC_REJET_F (PARAM_WID,DATE_WID,ERR_CODE, INTEGRATION_ID )

VALUES (vPARAM_WID,vDATE_WID,:SQLCODE, :SQLSTATE);

 

DECLARE CONTINUE HANDLER

FOR SQLEXCEPTION

INSERT INTO BD_OTV_DATA_PPR03.WC_REJET_F (PARAM_WID,DATE_WID,ERR_CODE, INTEGRATION_ID )

VALUES (vPARAM_WID,vDATE_WID,:SQLCODE, :SQLSTATE);

 

BT;

set QUERY_BAND = 'DELAYMAX = YES;' FOR TRANSACTION;

INSERT into W_CAMP_HIST_AP select W_CAMP_HIST_F.* from W_CAMP_HIST_F , WC_RETOUR_F , W_ASSET_D;

ET;

--- Error Code Got in SQL Assistant

---------------------------

Teradata TDATA.DLL

---------------------------

Request aborted by TDWM. Exception criteria exceeded: .

---------------------------

OK  

---------------------------