RE: How to Call stored procedure from RPG?

["Gary L Peskin" <garyp@xxxxxxxxxxxx>]

What exactly would you like to do?  A stored procedure can be either an
external procedure (basically, a *PGM object) or an SQL stored procedure
which consists entirely of SQL statements.  For the former, you call it
just like any other *PGM.  For the latter, see the "DB2 UDB for AS/400
SQL Programming Concepts" manual in the Information Center.  The section
"Invoking a Stored Procedure" is a good place to start.  The short
answer is that you use an SQL CALL statement from your SQLRPGLE program.

If you have specific questions after reviewing this material, please
come back and I'll try to help.

Gary

> -----Original Message-----
> From: java400-l-admin@midrange.com
> [mailto:java400-l-admin@midrange.com] On Behalf Of Joe Pluta
> Sent: Thursday, February 21, 2002 8:03 PM
> To: java400-l@midrange.com
> Subject: RE: How to Call stored procedure from RPG?
>
>
> Nope, I'm not a result set guy.  I saw your message in
> RPG400-L, though, and you're right, there really was no
> response.  I wish I could help, because I'd love to see an
> example of it.  Let me try to reword the question and see if
> we can't get an answer.
>
> Joe
>
>
> > From: Tanveer, Mohammad
> >
> > I did no response Guru do u have any idea.
> >
> > From: Joe Pluta [mailto:joepluta@PlutaBrothers.com]
> >
> > > From: Tanveer, Mohammad
> > >
> > > How to Call stored procedure from RPG?
> >
> > Hiya Mohammad!
> >
> > You might try posting this in the RPG400-L mailing list,
> for starters.
> >
> > Joe Pluta
> > Moderator
> > (Really!)
> >
> >
> >
> > _______________________________________________
> > 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.
>
> _______________________________________________
> 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.
>