RE: Embedded Dynamic S.Q.L. in RPGIV

[<Matt.Haas@xxxxxxxxxxx>]

Don,

If the statement is the same and you're using parameter markers and you
just want to change the values of the parameters, you don't need to
prepare the statement again. After you prepare the statement, you can
use the USING clause of the EXECUTE statement to set the values. There
is at least one example of doing this in the SQL Programming book.

Matt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Fisher, Don
Sent: Thursday, March 08, 2007 2:32 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Embedded Dynamic S.Q.L. in RPGIV

That's what I'm doing.  The trouble is the code needs to be executed
multiple times.  After the first time, I receive SQL0100 which says the
statement i.d. (sel in your example) is already in use.

Donald R. Fisher, III
Project Manager
RoomStore, Inc.
(804) 784-7600 ext. 2124
dfisher@xxxxxxxxxxxxx

<clip>
What I have in my embedded SQL is the following

c/EXEC SQL
c+ prepare sel from :Sqlstatement
c/END-EXEC
c/EXEC SQL
C+ EXECUTE sel
c/END-EXEC
<clip>