Re: Calling stored procedures from embedded SQL

wrote:

That's just what I was afraid of. Does 7.1 allow you to select which result
set to use if the procedure returns more than one?

Thanks for the info.
--


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Scott Klement
Sent: Wednesday, January 19, 2011 3:17 PM
To: RPG programming on the IBM i / System i
Subject: Re: Calling stored procedures from embedded SQL

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.

--
This is the RPG programming on the IBM i / System i (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 IBM i / System i (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.