DSXchange

Posted: **Mon Apr 23, 2007 3:02 pm**

I can write to AS400 DB2 tables directly using iSeries navigator. So, permission is NOT an issue. I can also read using the same stage. However, I cannot write from Datastage using Oracle Enterprise stage.

The error I get is:

ODBC,0: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400] tblTableName in dbDatabaseName not valid for operation.

Any ideas?

Posted: **Mon Apr 23, 2007 4:23 pm**

The ODBC drivers can be set to read only. Your user may not have write permission to this table.

Posted: **Tue Apr 24, 2007 11:34 am**

I don't think it is a permission issue. I can write looggin in with this ID using iSeries Navigator directly.

DSXchange

Problem in writing to AS400 DB2 tables from Datastage

Problem in writing to AS400 DB2 tables from Datastage