×
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 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.
midrange.com
