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:-


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.