Re: Calling an SQL stored procedure from RPGLE free-format

Great minds... link to greater minds. ;)

-Kurt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
Sent: Monday, March 25, 2013 1:57 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: Calling an SQL stored procedure from RPGLE free-format

Sure, it'll be embedded SQL - use the CALL statement.

Are you trying to get a result set? In older releases this was not possible in RPG. Now it is - and Scott Klement has this article that may help you -

http://www.iprodeveloper.com/article/sql/71-sqlrpgle-read-stored-procedure-result-sets-698483

If you are in an earlier release, your only hope is to upgrade of to use the SQL CLI (call-level interface). It works, but is just like low-level ODBC coding - and not much fun, actually!

HTH
Vern

On 3/25/2013 1:49 PM, William Howie wrote:

Hello all,

I think I have what should be an easy question............I would like to call an SQL stored procedure from within a free-format RPGLE program. Is that possible? Hopefully I'm not oversimplifying the question. Please advise, with examples if possible. Thanks!

Bill Howie
Software Developer
AmTrust North America
5800 Lombardo Center
Cleveland, Ohio 44131
216.328.6292

________________________________
Confidentiality Notice: This email message is intended only for the individual or entity to which it is addressed. This email may contain information that is proprietary or privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you received this email by accident, please notify the sender immediately and destroy this email and all copies of it.

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (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.