RE: Journaling required on SQL w/ UPDATE?

You are not being forced to journal the file, you are being required to
provide commitment control processing for the update.  On the create command
there is a keyword COMMIT() change it to COMMIT(*NONE) or use the SET
command with in the program.

Like the following
C/EXEC SQL                 
C+ SET OPTION DATFMT = *USA
C+   ,ALWCPYDTA = *NO      
C+   ,CLOSQLCSR = *ENDMOD  
C+   ,DLYPRP = *YES        
C+   ,COMMIT = *NONE
C/END-EXEC                 

Thank you,
Matt Tyler
WinCo Foods, LLC
mattt@xxxxxxxxxxxxxx


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Dan
Sent: Thursday, July 14, 2005 10:50 AM
To: RPG400-L@xxxxxxxxxxxx
Subject: Journaling required on SQL w/ UPDATE?

Somehow I don't remember being forced to journal a file when updating
it via embedded SQL.  Is there a way to avoid this?  An option I
forgot about?

TIA, 
Dan