RE: How to Call stored procedure from RPG?

Oh, you want to get a result set back!  See the Redbook at
http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246503.pdf entitled
"Stored Procedures and Triggers on DB2 Universal Database for iSeries".
>From page 62:  "Some traditional programming languages, such as RPG and
COBOL, cannot retrieve result sets returned by a stored procedure,
unless they use the SQL Call Level Interface for the stored procedure
call."

For more information on that, see the "SQL Call Level Interface (ODBC)"
book.  The examples are in C but you can call these same routines from
RPGLE using a prototype.

A good discussion (and examples) can be found in the Redbook "Who Knew
You Could Do That with RPG IV? A Sorcerer's Guide to System Access and
More"
(http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg245402.
html?Open)  Chapter 6.5 is all about using the CLI from RPGLE.  Section
6.5.8.1 has the source code for a sample RPGLE program using CLI.

If you know ODBC, it's pretty simple to understand.  Otherwise, you're
in for somewhat of a learning curve.  Chapter 6.5 is a good place to
start.

HTH,
Gary

> -----Original Message-----
> From: java400-l-admin@midrange.com
> [mailto:java400-l-admin@midrange.com] On Behalf Of Tanveer, Mohammad
> Sent: Thursday, February 21, 2002 4:28 PM
> To: 'java400-l@midrange.com'
> Subject: RE: How to Call stored procedure from RPG?
>
>
> Hut how can get the result set back in RPG?
>
> -----Original Message-----
> From: cjacobsen@medcogroup.net [mailto:cjacobsen@medcogroup.net]
> Sent: Thursday, February 21, 2002 6:24 PM
> To: java400-l@midrange.com
> Subject: Re: How to Call stored procedure from RPG?
>
>
>
> Call the program like you would any other CL or RPG program
>
> Craig Jacobsen
>
> _______________________________________________
> This is the Java Programming on and around the iSeries /
> AS400 (JAVA400-L) mailing list To post a message email:
> JAVA400-L@midrange.com To subscribe, unsubscribe, or change
> list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
> _______________________________________________
> This is the Java Programming on and around the iSeries /
> AS400 (JAVA400-L) mailing list To post a message email:
> JAVA400-L@midrange.com To subscribe, unsubscribe, or change
> list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>