Use RPG to get a results set from a stored procedure -- RPG400-L

Subject: Use RPG to get a results set from a stored procedure
From: Mike Cunningham <mcunning@xxxxxxx>
Date: Mon, 3 Mar 2008 11:30:30 -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 AS400 / iSeries <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 just read this article from Scott Klement http://systeminetwork.com/article/jdbc-rpg-multiple-result-sets and it made me wonder that if RPG can deal with a result set coming back from a remote database stored procedure, if there has been any recent changes to RPG and using a DB2/400 external stored procedure written in RPG and reading one of more result sets from that local stored procedure. I would think the RPG app could use this tool to make a JDBC connection to DB2 on the same system and execute the procedure but it just seems like the long way around.

As an Amazon Associate we earn from qualifying purchases.

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