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
Error when we tried to insert records into DB2 i Series
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 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
2. Check http://publib.boulder.ibm.com/infocente ... /n7008.htm
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
Please review this link for further information on journalling;
http://publib.boulder.ibm.com/infocente ... rjrnpf.htm