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

The statement is a select and what changes is the location number.  I could 
redesign the program to use a different s.q.l. statement when many location 
numbers are being processed, but I don't like that option much based on what 
I'd have to change.

Are you able to execute that code multiple times during the same program 
invocation?  

Hmmmm...I wonder what would happen if I placed the s.q.l. code in a 
sub-procedure?

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

<clip>
-What's the statement? SELECT, DELETE, INSERT...
-What's changing between runs?

I've had no problem running the following multiple times at v5r3...
     c/exec SQL
     c+   prepare S1 from :wSqlStatement
     c/end-exec

     c/exec SQL
     c+   declare C1 scroll cursor for S1
     c/end-exec

     c/exec SQL
     c+   open C1
     c/end-exec
<clip>