Problem in writing to AS400 DB2 tables from Datastage

[abc123]

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?

[kduke]

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

[abc123]

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