RE: Journaling required on SQL w/ UPDATE?

1) CRTSQLRPGI   COMMIT(*NONE)

2) 
c/exec-sql
c+ set option commit = *NONE
c/end-end

3)
c/exec-sql
c+  update myfile set myfield = '1'
c+    with NC
c/end-exec


HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Dan
> Sent: Thursday, July 14, 2005 12:50 PM
> 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
> 
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) 
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
>