Hi

I am using 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 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.]

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

Needless to mention that StarSQL executes the query without errors.

Any ideas? Thanks.