The SQL on Worldship is limited to a INSERT command. So what we did is use the Export function which can be triggered at the end of a transaction (all pkgs) or at the end of the day. The export function then writes the data in append mode to a file on a SAMBA directory on AIX. Then every 1/2 hour a UV job reads the file, updates the orders and then deletes the file.
Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Brutzman, Bill Sent: Wednesday, August 19, 2009 7:37 AM To: U2 Users List Subject: [U2] U2 and UPS WorldShip The main thing we need with United Parcel Service is to get the 1Z... tracking number back into UniVerse. I found that, via ODBC, WorldShip can read a packslip file from UniVerse and import all of the packslip data but WorldShip stalls when trying to write the data back to UniVerse via the same ODBC connection. Thus, it appears that we have to export the UPS data to Microsoft SQL Server and then use another ODBC (JDBC or .Net) connection to read the 1Z from SQL Server and then write the 1Z to UniVerse. Insights or alternative approaches would be appreciated. --Bill _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
