RE: Embedded SQL question

["Haas, Matt" <Matt.Haas@xxxxxxxxxxx>]

You don't need the F spec but it will not cause the file not to be
updated. You need to check the value of SQLCOD after the update
statement. If it's not '00000', you need to check the error code to see
what it means (I posted a link to the list of SQLCOD's last Friday). If
you run it with debugging started, the job log will contain this
information in it.

Chances are, it's complaining about the file not being journaled. The
two options are to either journal the file or execute the statement
without using commitment control (check the archives for examples of the
different ways to turn it off).

Matt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Michael Jacobsen
Sent: Monday, September 19, 2005 11:31 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Embedded SQL question

I am trying to update multiple rows in a externally described file using

embedded SQL.  This is the entire sqlrpgle program.  It compiles and 
completes successfully, but I am not seeing any changes in the file.  Am
I 
leaving something out?  According to all examples I have seen, this
should 
be all I need.


Filename    UF   E           K Disk 

C/Exec SQL 
C+            Update Filename
C+               Set Field1 = 0 
C+               Where Field2 = 2005243 
C/End-Exec 
 
C                   Eval      *InLr = *On 


Thanks,

Mike