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)
Related Q&A from Shahar Mor
Use work station customize object or printer type in iSeries Access to print the output of an RPG file from the AS/400 to an HP printer. Continue Reading
What to do when an application is published in IFS from Win2k3 server, and users are unable to access the shared folder on AS/400. Continue Reading
Connecting the iSeries in AS/400, issue STRHOSTSVR *ALL. Make sure the as-signon port is in listen state and check the firewall settings. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.