Home > IT Answers > AS/400 > Insert and update DB2 from SQL Server 2000 using OLEDB
Sandy55
5 pts.
 Insert and update DB2 from SQL Server 2000 using OLEDB
AS/400, DTS, SQL Server 2000
I am using AS/400 and SQL Server 2000 and trying to insert and update from SQL Server. When I run a DTS from SQL Server 2000, SQL Server 2000 is able to read the table from AS/400 but when I run a DTS from SQL Server 2000 to insert or update a table on AS/400, it does not do anything. No error, but no update or insert. I am working on that for already 2 months and no improvement. Plz help me.

Software/Hardware used:
ASKED: February 6, 2008  9:42 AM
UPDATED: June 29, 2010  12:53 PM
RELATED QUESTIONS
Answer Wiki:
How are you moving the data from the SQL Server to the AS/400? Are you using a data transformation, linked server with the query being run by the DTS package, etc?
Last Wiki Answer Submitted:  February 9, 2008  2:13 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Were you able to resolve the issue?

Denny Cherry
 64,520 pts.
 

Check the permissions on the AS400 tables (files), and insure that journaling is turned on for them as well.

Although the messages are not useful sometimes (“OLEDB2 … has a catastrophic error” for instance), there should be something in the log.

Code2live
 55 pts.
 

INSERT and UPDATE operations require Journaling to be started on the physical file (underlying the TABLE) on the AS400.
Hope this helps!

Code2live
 55 pts.