×
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.
Mike,
Your PARAMETER STYLE is set to SQL, however your parameter list looks like
it should be set to GENERAL. I would change the create to PARAMETER STYLE
GENERAL and try again.
Thank you,
Schadd Gray
Damon Technologies, Inc.
www.damontech.com
-----Original Message-----
From: Mike Wills
Sent: 03/09/2011 8:57 AM
To: Midrange Systems Technical Discussion
Subject: iSeries stored procedure calling RPG program doesn't return a
valueto the program
I am not sure what is going wrong here. I have a stored procedure that
calls an SQLRPGLE program. The program is running fine as I have
verified in the debugger and sends the return value as expected. What
is returned to my ASP.NET program when looking at
`cmd.Parameters["@ISMATCH"].Value` is {}. I am guessing I am doing
something wrong. What could it be? How can I test calling the stored
procedure to make sure the procedure is working as expected.
My RPG program:
// Entry Parms
D MPRLRCHK PR extpgm('MPRLRCHK')
D id 10P 0
D isMatch 1A
The stored procedure:
CREATE PROCEDURE "MPRLIB"."CHECKHOURS" (EMPLOYEEID DECIMAL(10 , 0),
INOUT ISMATCH CHAR(1))
LANGUAGE RPGLE
PARAMETER STYLE SQL
NOT DETERMINISTIC
MODIFIES SQL DATA
SPECIFIC CHECKHOURS
NEW SAVEPOINT LEVEL
EXTERNAL NAME 'MPRLIB/MPRLRCHK';
I have the rest of the code documented at
http://stackoverflow.com/q/5238834/2535.
--
Mike Wills
http://mikewills.me
midrange.com
