Error when we tried to insert records into DB2 i Series

satheesh_color · Post by **satheesh_color** » Thu Jun 17, 2010 2:58 am

Hi All,

When we try to insert the records into the DB2 I series tables we got the below error messages:

CIP_SKU_Price,0: [IIS-CONN-ODBC-000004] ODBC function "SQLExecute" reported: SQLSTATE = HY000: Native Error Code = -7008: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]OUSKUPRICE in ENTERPRISE not valid for operation. 3 (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 559)

Please let me know your suggestions.

Thanks,
Satheesh

ArndW · Post by **ArndW** » Thu Jun 17, 2010 3:30 am

1. Have you tried your SQL query directly in DB2 from the command line?
2. Check http://publib.boulder.ibm.com/infocente ... /n7008.htm

Bongo51 · Post by **Bongo51** » Fri Jun 25, 2010 7:52 am

Please ensure that the db2 table/file on the Iseries is journalled. Journalling on an iseries file gives the file table logging abilities therefore emulating a database table proper.
Please review this link for further information on journalling;

http://publib.boulder.ibm.com/infocente ... rjrnpf.htm