Re: IBM i connection with MS access

1.) where can i check this connection options like
SET OPTION COMMIT = NONE ?

2.) also does this error appear when 1) trying to update any file using
MS access which is not journaled or 2) does it appear when someone runs
SQL query to update the same file which is not journaled using MS access ?


Thanks.

On Fri, 25 Mar 2022 at 16:48, Rob Berendt <rob@xxxxxxxxx> wrote:

But he was concerned because the error was NOT appearing.

There are options in SQL, like WITH NC, which turns off commitment control
and thus cares not a whit about journaling.
There also connection options like
SET OPTION COMMIT = NONE
which will turn off commitment control too. I believe this capability is
also in your connection setup.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Jack Woehr via MIDRANGE-L
Sent: Thursday, March 24, 2022 3:53 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: IBM i connection with MS access

CAUTION: This email originated from outside of the organization. Do not
click links or open attachments unless you recognize the sender and know
the content is safe.


"This error comes from the database itself : the SQL7008 message is usually
a journaling issue indicating that either the updated file or database is
not journaled, or that the current environment does not have authority to
its journal."


https://www.ibm.com/support/pages/error-javasqlsqlexception-sql7008-during-rule-execution-server-diagnostic

Looks like you're trying to do something in SQL you can't do on a file
that's not jourmalled.

On Thu, Mar 24, 2022 at 11:22 AM jerry ven <jerryven95@xxxxxxxxx> wrote:

I tried updating a file using MS access and the file was not journaled

but

when i clicked on save button in MS access after making any data entry

in

any of the field which was opened in MS Access for a particular file

then

this error ' "[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008" was not
appearing.

--
Jack Woehr, IBM Champion 2021-2022
<
https://www.youracclaim.com/badges/528d23d6-087f-4698-8d17-d59688106ac4/public_url

Absolute Performance, Inc.
12303 Airport Way, Suite 100
Broomfield, CO 80021

NON-DISCLOSURE NOTICE: This communication including any and all
attachments is for the intended recipient(s) only and may contain
confidential and privileged information. If you are not the intended
recipient of this communication, any disclosure, copying further
distribution or use of this communication is prohibited. If you received
this communication in error, please contact the sender and delete/destroy
all copies of this communication immediately.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com