×
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.
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>
As an Amazon Associate we earn from qualifying purchases.