RE: Embedded SQL in RPGLE pgm

Are you trying to update field names where they are contained in a program
variable (ctrName in this case)?  If you are, I believe you need to use a
dynamically built SQL statement.  

You build the SQL statement in a variable and use PREPARE and EXECUTE.  I
have some examples if you are unable to locate any.  

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

<clip>
any examples of an UPDATE statement using field names that I want to build.
I know how to do it using a plain SELECT statement and creating a 
literal statement and then running it.  But what I'm trying to do this time
is something like:
     C/Exec Sql
     C+ UPDATE PUBWRK/WPUSCHEDLE 
     C+ SET %Trim(ctrName) = %Char(retField), 
     C+ %Trim(appName) = %Char(retField)
     C+ WHERE %Trim(dateName) = %Char(inPickupDate)
     C/End-Exec 

<clip>