Hi,

I can't insert/update a table using odbc connection in data migrator. Following log is the error I'm getting. Please help!

--------------------------------------
Submitted immediately
Request - LOADTESTQ2 (Owner: webfocus) submitted.
f558600c_q2 type ODBC Existing target
Issuing PREPARE
Starting Load
(FOC1400) SQLCODE IS -7008 (HEX: FFFFE4A0)
: [S1000] [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - F558600C in
: TESTDTA not valid for operation.
(FOC1740) EXECUTE ERROR : F558600C_Q2
-- stats for source file
1 : Row(s) processed by job
0 : Row(s) rejected due to format error
-- stats for target file: f558600c_q2
1 : Row(s) processed by job
1 : Row(s) accepted by target table
0 : Row(s) inserted into target table
0 : Row(s) updated in target table
0 : Row(s) deleted from target table
0 : Row(s) rejected due to validation errors
0 : Row(s) rejected due to no match
0 : Row(s) rejected because duplicate exist
0 : Row(s) rejected due to DBMS error
Ending Load
Return Code = 1740
Request: LOADTESTQ2 - finished processing
CPU Time : 94
Finished
Elapsed run time 0:00:01

Hi all,

FYI, Shirley has a case opened regarding this issue.

Shirley, please keep us posted on any update/progress. Thank you in advance for sharing with all.

Cheers,

Kerry

The case is now closed. The resolution is to turn on the journaling in AS400 tables.