RE: Embedded SQL in RPGLE pgm

After the PREPARE, use EXECUTE as follows:
C/Exec SQL EXECUTE mainSelect using :mainStatement

If you want to update the file, change "Select * from" to "Update" and add
the appropriate SET clauses.

Hope that helps. 

Donald R. Fisher, III
Project Manager
Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@xxxxxxxxxxxxx

<clip>
     * Prepare Select Statement
     C/Exec Sql
     C+ Prepare mainSelect From :mainStatement
     C/End-Exec 

So I'd just build my updateStatement and how would the C/ and C+ statements
work?
<clip>