RE: RNF 5346 - when calling SQL store procedure with const variable

How did you define the lrRequestLoginResetSP stored procedure? Perhaps the piUserID parameter is defined as IN/OUT, when it should only be IN...

-Eric DeLong

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Hockchai Lim
Sent: Thursday, November 15, 2012 2:02 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RNF 5346 - when calling SQL store procedure with const variable

I'm getting a RNF5346 error when trying to call a sql stored procedure. The error appears to be caused by passing the stored procedure with a const variable, which makes sense that I got the compile error. Is creating a temp piUserID variable be the only option to get around this problem?


The RPG PI looks like below:
P lrRequestLoginReset...
P B export
D pi
D piUserID 10 varying const
D piResEml 100 const
D piErrFlag 1
D piErrID 7
D piErrMsg 255


The sql call statement looks like below (note: piUserid is const varying length
exec sql call lrRequestLoginResetSP(:piUserid, :piResEml, :m4ErrFlag, :m4ErrID, :m4ErrMsg);


The compile error is as follow:
49200 C SQL_00009 IFEQ '1' SQ
49200 C EVAL PIUSERID = SQL_00011 SQ
=====> aaaaaaaa
RNF5346 30 a 049200 The operation modifies the field, but the field cannot be