I can pull data from AS400 to SQL but cannot get my command on the SQL server to push the data back. This is a very small process, I only need an item number and date.
Also, the date on the SQL db is "datetime". I'll need to convert that to a more recognizable date field to put in the AS400 db.
To be clear, the connections are in place, I have a linked server set up, and the db2 file is journaled.
Any assistance would be appreciated!
AS400, SQL Server 20005
October 29, 2010 3:52 PM
November 3, 2010 11:29 AM