RE: Write to iSeries via ODBC

["Guy Terry" <guy.terry@xxxxxxxxxxxxxxxxxxx>]

Chuck,

BTW, according to IBM Document 862569B200550644, your summary below looks
pretty good.

Ta

Guy

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: 12 November 2007 21:45
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Write to iSeries via ODBC

   I expect there is still no requirement to journal, given the 
necessary isolation level is established.  I believe after v5r2 a 
/correction/ was made to the relationship between features of 
auto-commit and isolation level of *NONE, such that a tweak to the 
settings may be required after such a transition.
   I can not recall the details nor releases.  Sorry.  However, I 
believe auto-commit on v5r2 was implemented with isolation level *NONE; 
i.e. COMMIT(*NONE).
   Assuming the change after that release was to make the /auto-commit/ 
feature really match its name, then presumably it now runs with an 
isolation level other than *NONE, and thus automatically & implicitly 
issues a COMMIT after each statement.  Thus to enable update without 
journaling, set auto-commit to *NO [and keep the isolation level set to 
*NONE].

Regards, Chuck