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
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
Searching for the right API to add users to an EIM SSO implementation? The IBM site includes sample APIs based on C. 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.