Problem solve Get help with specific problems with your technologies, process and projects.

SQL7008 error in iSeries Access and journals

SQL7008 error in iSeries Access is most frequently caused by trying to update a file that is not journaled or when a user lacks authority to the journal.

I am trying to load a file from iSeries Access but the system will not accept the file. I am getting an SQL7008 error [IBM][iSeries Access ODBC driver][DB2 UDB]SQL7008-MCNTRBO in MAILER not valid for operation. (#-7008).

This file is to be created on the iSeries from my PC.

SQL7008 is most of the time caused by trying to update a file that is not journaled or you do not have authority to its journal. Journal the file using command STRJRNPF (files on iSeries are not automatically journaled unless defined by using SQL).

If the file is created by you on a libray it is not auto-journaled, try to create the file in a schema (i.e create schema "myschema" and create table in "myschema").

Dig Deeper on iSeries Access (Client Access)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.