Re: SQL Stored Procedure ROW_COUNT

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 05/17/2016
07:15:55 AM:

First of all let me say that I'm even more of a newbie.
But, what happens if you move this:
GET DIAGNOSTICS CNT2 = ROW_COUNT;
to
GET CURRENT DIAGNOSTICS CONDITION 1 CURSTATE = RETURNED_SQLSTATE;
GET DIAGNOSTICS CNT2 = ROW_COUNT;

That worked. Thanks. Don't know why having an IF statement
between the two should be throwing it off since the statements between the
IF and END IF are skipped when there are no errors. So, this is working:

DELETE SHR460/IMIOVMET
WHERE Company_Number = COMPNUMB
AND Company_Period = COMPPERD;
GET CURRENT DIAGNOSTICS CONDITION 1 CURSTATE = RETURNED_SQLSTATE;
GET DIAGNOSTICS ROWCOUNT = ROW_COUNT;
IF SUBSTR(CURSTATE,1,2) <> '00' THEN
SET STR1 = ERRPFX || 'IM IOV M/E data delete failed.'
|| ' (' || CURSTATE || ')';
SIGNAL SQLSTATE '88W08' SET MESSAGE_TEXT = STR1;
END IF;


Sincerely,

Dave Clark