RE: Stored Procedure? with Result Set.

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Tim,

I looked for this once, but never really tried it.  It seems you must use
DB2 CLI api calls to populate the result set.  I recall some decent examples
of CLI in the Sorcer's Guide.....  Perhaps this will help....
;)

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Hatzenbeler, Tim [mailto:thatzenbeler@xxxxxxxxxxxxx]
Sent: Monday, March 10, 2003 11:40 AM
To: 'RPG programming on the AS400 / iSeries'
Subject: Stored Procedure? with Result Set.


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.