Re: SQL Stored Procedure ROW_COUNT

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

The SNIPped example showed how to get the effective ROW_COUNT value,
i.e. the same value as that stmt-info-item, from the SQLERRD(3);
notably, use of the supported condition-information-item of
DB2_SQLERRD3

Sorry, yes, I definitely missed that distinction. The following
is working. Thanks.

DELETE SHR460/IMIOVMET
WHERE Company_Number = COMPNUMB
AND Company_Period = COMPPERD;
GET CURRENT DIAGNOSTICS CONDITION 1 CURSTATE = RETURNED_SQLSTATE
, ROWCOUNT = DB2_SQLERRD3;
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;

The convention for the signature delimiter [as documented, IIRC, in
either or both of, every mailing and the monthly **admin reminders for
the email-list], is a single line on which there are only the three
characters [where the term "dash" is synonymous with "hyphen", and the
term "space" is synonymous with "blank"]:
dash, dash, and space

Is my "signature delimiter" below working? I can't tell because
the bounced email back to me still has everything after the delimiter
still intact as sent.

Sincerely,

Dave Clark