RE: Stored Procedure? with Result Set.

["Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx>]

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.