RE: Write to iSeries via ODBC

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