Re: Calling stored procedures from embedded SQL

Actually not to bad - Scott has excellent examples that I just recently
implemented on a V5R4 system. Cut and paste.



Terry Bullard – Applications Programmer Analyst





From: Glenn Hopwood <ghopwood.list@xxxxxxxxx>
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Date: 01/19/2011 03:34 PM
Subject: Re: Calling stored procedures from embedded SQL
Sent by: rpg400-l-bounces@xxxxxxxxxxxx



I don't think it's possible until 7.1 (6.1 maybe?).

I believe you can do it via the CLI but that's quite a bit more involved
then embedded SQL.

Glenn

On 1/19/2011 2: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.

--
[Description: beflogo160]
John Maassel
IBM i Programmer/Analyst
3776 South High Street
Columbus, OH 43207
Phone: (614) 492-7413

Bob Evans makes the holidays easier. Our Farmhouse Feast is a complete

holiday meal to go, ready to heat at home, serve and enjoy. Serves 6-8 for
just $74.99. Pre-order through your local Bob Evans or online at
www.bobevans.com/onlineordering<http://www.bobevans.com/onlineordering> .