Re: CPF7CFD Error occurred running REXX procedure

Hi,

I have a job that has crashed with this message. Looks like a bug to me
but maybe someone will spot something. Thanks.



A CLP is called that issues a STRREXPRC with an sql statement 'DELETE
FROM MYFILE'

CHGVAR VAR(&SQL) VALUE('DELETE FROM ' *CAT &myfile)
EXECSQL CMD(&SQL)
MONMSG MSGID(SQL0000)

This command calls the rexx procedure below :


PARSE ARG iSql
RC=0

ADDRESS EXECSQL,
EXECSQL 'SET OPTION COMMIT = *NONE'
ADDRESS EXECSQL,
EXECSQL iSql

IF RC <> 0 THEN DO
MSGID = "SQL"RIGHT(STRIP(ABS(SQLCODE)),4,'0')
'SNDPGMMSG MSGID(&MSGID) MSGF(QSQLMSG) MSGDTA(&SQLERRMC)
MSGTYPE(*ESCAPE)'
END


The same CLP has been called over 5000 times for 5 different
multimember files. An override on the member is issued by the CLP
calling program. Mostly, the rexx procedure is returning SQL100 that is
ignored on returning to the CLP.

In the log, I've got this :

Erreur. MCH1210 non interceptà par QSQREXX à la spÃcif *N, inst
X'0617'.
6 *-* Address EXECSQL EXECSQL iSql;
+++ RC(CPF9999)
10 +++ MSGID = 'SQL'RIGHT(STRIP(ABS(SQLCODE)), 4, '0');
Error in line 10: Bad arithmetic conversion.

Error occurred running REXX procedure EXECSQL.

And in the dump :
DUMP TAKEN FOR UNMONITORED ESCAPE MESSAGE

.MESSAGE ID- MCH1210

.MESSAGE FILE- QCPFMSG LIBRARY-
*LIBL
.SEVERITY- 40

.MSGTYPE- 0F

.SENDING-

..PROGRAM- cblabranch

LIBRARY-

..INSTRUCTION- 000040

.RECEIVING-

..PROGRAM- QSQREXX LIBRARY-
QSYS
..INSTRUCTION- 0617

.MESSAGE-

Zone rÃceptrice trop petite pour contenir le rÃsultat




--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.