RE: Embedded SQL in RPGLE pgm

I don't think you can use rpg bif (%trim, %char) in sql.

The best way to verify embedded sql codes is to try it in interactive sql.  
Just substitute all the rpg variables with the value you want to test with.


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of RPower@xxxxxxxxxx
Sent: Thursday, August 04, 2005 10:10 AM
To: RPG programming on the AS400 / iSeries
Subject: Embedded SQL in RPGLE pgm


Ok,
I've searched the archives but can't find (or don't know what I'm looking 
for) 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 

but I don't think I'm doing this right at all am I?
Frustrated beyond all belief today...

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
709-576-8132
rpower@xxxxxxxxxx
http://www.stjohns.ca/
___________________________________________________________________________
Success is going from failure to failure without a loss of enthusiasm. - 
Sir Winston Churchill