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
On the AS/400 library, source files are multi-member. View source files using GET QCLSRC.membername or MGET QRPGSRC.* 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