|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.