All,

I'm going through the article series "RPG to the Web", the basis of which
was to use RPG/SQL to return data to a variety of front-ends. The RPGs are
registered as SQL external stored procedures that return result sets to
calling programs which format and present the data in 5250, HTML, etc.

My understanding from reading the Redbook is that the 'DYNAMIC RESULT SETS
x' keyword should be included in the 'CREATE PROCEDURE' command so the
calling program knows to expect returned data from the called procedure.
This value is stored in the qsys2.sysroutines table. The examples in the
article do not use that keyword, but the examples work nonetheless.

My question is: in the examples, how does the calling routine know to
expect a result set? Does the CRTSQLRPGI update or override the value in
sysroutines?

http://systeminetwork.com/article/rpg-and-web-technologies-get-there-0

Many thanks, JK


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.