Re: Calling RPG Program as Stored Procedure without Declaring As A Stored Procedure - Seems to Work in V7R3

Maybe I've been living in a cave, but I always thought that if I wanted to
call a program and pass parms to it from the Client Access/400 database
drivers I needed to first declare a stored procedure unless of course I was
using the old OLEDB drivers.

Then in my .Net code I would declare a cmd object and pass the parms in
and out of the stored procedure call individually as command parameters.

This has always been a bit painful because of the need to declare a stored
procedure to call an RPG program.

Since I have been recently been testing some of the DB2 CLI functionality
I have now found that I can send the following in as a standard SQL
statement instead of a SQL SELECT:

call libname.userauth1('USER1 ','PASS1 ')

The SQLRPGLE program has a multi-element data structure declared with xx
number of elements. I then process my business logic, populate the array
with data and return it as a resultset instead of parms and I can simply
read the result set fields in .Net or any other language that can get
resultsets including using the DB2 CLI command from PASE.

This opens up the world of calling pretty much any RPG program with parms
that can then return a list of parm values in a single record or
multi-record resultset rather than passing back as parms.

It has the added benefit of no more creating stored procedure wrappers if
this is true.

Does anyone else make calls to RPG logic using this technique of passing
back a resultset from RPG instead of parm returns and not having to
register a stored procedure ?

Feedback welcome.

Regards,

[
http://static.helpsystems.com/hs/email/templates/signatures-final/images/hs-logo2.png
]

Richard Schoen
Director of Document Management

e. richard.schoen@xxxxxxxxxxxxxxx<mailto:richard.schoen@xxxxxxxxxxxxxxx>
p. 952.486.6802
w. helpsystems.com<http://www.helpsystems.com/>
[cid:image002.jpg@01D1A545.4C2BF250]<
http://www.linkedin.com/in/richardschoen

[cid:image003.jpg@01D1A545.4C2BF250]<http://www.twitter.com/richardschoen

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com