RE: SQL Problem

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

Terri,

There's basically three (I think) options.

1) Journal the file
2) Add WITH NC to the end of the SQL (WITH NC = with No Commitment control)
3) I think there's a compile option to turn off commitment control

Matt

-----Original Message-----
From: THarteau@felkerbrothers.com [mailto:THarteau@felkerbrothers.com]
Sent: Friday, December 20, 2002 9:15 AM
To: RPG400-L@midrange.com
Subject: SQL Problem


Hi,
      I have been using SQL for a bit now and was getting pretty confident
about it. Now I'm getting an error I don't understand. I have the following
statement in an RPG program to update all the records that meet the
criteria:
      C/EXEC SQL
      C+ UPDATE FLTL03 SET TFWSID = :WSIDJ, LTSTS = '1S'
      C+  WHERE TFWSID = :WSIDS AND LTSTS = '  '
      C/END-EXEC

Its not working.  I am getting SQL error code 7008. We don't journal any
files, and this is the only place in the program I use this file.  This is
in my test environment.  I was using the physical file first, and that
didn't work either. Any ideas on how to make this work?
<snip>