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)
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.