RE: Stored Procedure? with Result Set. HELP

Hello:

Need help in this matter. The SQL command you are talking about, where is it
invoked from. I am trying to write an ASP page and
and call a RPGLE program to do the same thing you are talking about. Can
some one tell me how to make that call. Now the RPGLE program should it be
compiled with any special options. How about the in and out stuff you are
talking about?. Is RPG program going to end with a return and that is what I
get as OUT.

I am new to this and would like some help.

Can you please give me a sample code if possible calling the RPGLE program
and getting the results in a DS as an OUT parm.

Thanks for the help in advance.
GG

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Hatzenbeler, Tim
Sent: Wednesday, March 12, 2003 4:22 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: Stored Procedure? with Result Set.


Thanks...  I got it to work, but unfortuantly, the calling program, didn't
want a result set...  It wanted just the in,out paramaters... So I did get
it to work...

But as for returning a result set, I worked with the example,. that placed
the values in a mult-occr-ds and it worked... But I didn't like being
constrained to the limits of a DS, but then again, by the time I filled that
DS, my end users would not be happy...  But for night time batch jobs, I
would like unlimited result sets...

But oh well, I look forward to reading your article...

tim

> -----Original Message-----
> From: Gary Guthrie [SMTP:garyguthrie@xxxxxxxxxxx]
> Sent: Wednesday, March 12, 2003 2:00 PM
> To:   RPG programming on the AS400 / iSeries
> Subject:      Re: Stored Procedure? with Result Set.
>
> Watch for tomorrow's newsletter. There's some info there for you.
>
> Gary Guthrie
> Editor, Club Tech iSeries Programming Tips newsletter
>
>
> "Hatzenbeler, Tim" wrote:
> >
> > Can this be done?
> >
> > I would like to issue a sql command (my guess is, a stored procedure),
> but I
> > might be wrong...  But I would like to execute a RPGLE program, that
> would
> > create a muliple line result set, that can be passed pack to the calling
> SQL
> > statement.   But I would like to use native IO commands in the RPG
> program,
> > reade and chains...
> >
> > Thanks, tim
> > This e-mail message, including any attachments, is for the sole use of
> the
> > intended recipient(s) and may contain confidential or privileged
> > information.  Any unauthorized review, use, disclosure or distribution
> is
> > prohibited.  If you are not the intended recipient, please contact the
> > sender by reply e-mail and destroy the message.
> > _______________________________________________
> > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review, use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.