Re: Stored Procedures -- RPG400-L

Subject: Re: Stored Procedures
From: Vern Hamberg <vhamberg@xxxxxxxxxxx>
Date: Wed, 18 Mar 2009 12:08:44 -0500
List-archive: <http://archive.midrange.com/rpg400-l>
List-help: <mailto:rpg400-l-request@midrange.com?subject=help>
List-id: RPG programming on the IBM i / System i <rpg400-l.midrange.com>
List-post: <mailto:rpg400-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=unsubscribe>

I don't think we were ever limited to only using an array result set (or MODS in the former days). I remember a limit of only 1 array-type result set. But you could have several cursor-based result sets - just leave them open when the program ends.

Right?
Vern

Glenn Hopwood wrote:

I don't think the below is true any longer. In RPG you are no longer limited to only returning an 'array' result set.

Charles Wilt wrote:

The only downside, at least with RPG,
is you need to know the number of records that will be returned.

Follow-Ups:

Re: Stored Procedures , Glenn Hopwood

This mailing list archive is Copyright 1997-2026 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.