Hi

I am using MS SQL Server to connect to iSeries DB2 on AS/400 with Linked Server through ODBC DSN. I was able to run SELECT using four-part naming convention in MS SQL Query Analyzer. But INSERT is not working. Here's my query:-

INSERT INTO LINKEDSERVER1.CATALOG1.SCHEMA1.TABLE1 (COL1)
VALUES ('VAL1')

It generates the following error.

OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - TABLE1 in SCHEMA1 not valid for operation.]

Needless to mention that StarSQL executes the query without errors.

The file is not journaling. I have already set COMMIT to *NONE. So it should work in SQL Query Analyzer. But it does not.


Any ideas? Thanks.

If the iSeries files has no members you will also get the same error. Try adding one member to the file.