Re: Stored Procedures in RPG

["Andrew Lutz" <alutz@xxxxxxxxxxxx>]

My understanding is that you can only return a result set to CLI based program 
on the AS/400, of course there is lots of options from a external point of 
view.....ODBC, JDBC ADO etc....

>>> rob@dekko.com 02/22/02 05:48AM >>>

Joe, that is an excellent request, and I'd like to see that also.

Have you also thought about using UDF's for some things?  Granted there are
situations where one or the other are a better fit.  I've got a good
explanation end-to-end of UDF's.

Me and this other bloke here coded an application that returns a result set
but currently we only call it from Domino.  It accesses BPCS.

> So I guess I'm looking for an end-to-end example of an RPG program using
the
stored procedure syntax of SQL to call a second RPG program that returns a
result set.


Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin

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