Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Data Migrator insert/update error foc1400 sqlcode 7008
Go
New
Search
Notify
Tools
Reply
  
Data Migrator insert/update error foc1400 sqlcode 7008
 Login/Join
 
Gold member
posted
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


Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16
 
Posts: 55 | Registered: May 05, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
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


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
Gold member
posted Hide Post
The case is now closed. The resolution is to turn on the journaling in AS400 tables.


Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16
 
Posts: 55 | Registered: May 05, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Data Migrator insert/update error foc1400 sqlcode 7008

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.