× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.