Re: Calling stored procedures from embedded SQL -- RPG400-L

Subject: Re: Calling stored procedures from embedded SQL
From: Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>
Date: Wed, 19 Jan 2011 14:16:39 -0600
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>

hi John,

You can't do that in embedded SQL at v5r4.

That ability was added to embedded SQL at version 7.1. Earlier versions can't do it through embedded SQL, so folks would use CLI or JDBC from RPG.

On 1/19/2011 1:39 PM, Maassel, John R. wrote:

Is there a way to use a result set from calling a stored proc from
RPG via embedded SQL? A quick Google search doesn't show anything
useful-the only examples IBM gives are ODBC, JDBC and CLI. We're on
V5R4.

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

RE: Calling stored procedures from embedded SQL , Maassel, John R.

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.