We are doing this with separate ODBC account that has a subset of dictionaries with I-descriptors that call subroutines to extract the required data back to UPS. The VOC entries on the ODBC account point back to the production data. We used a different logon since we did not want our Universe application to execute all the "startup/login" for a typical menu based user. The first transaction of the day takes the longest time to execute. You need to have all the data elements defined in the @SELECT and dictionary items should not have "." period but instead an underscore(AR.ID -> AR_ID). Another reason we use a separate dictionary. Also, make sure to follow all the steps in the HS.ADMIN for your ODBC account, and anytime you and a new dictionary item or compile an I-descriptor.
We have been doing this for about 4 years. Since, ODBC only supports INSERT and UPDATE, we have a UPS script the executes after each shipment and 'appends' the ship-out data to a SAMBA directory on our UNIX box and then a phantom routine runs every 15 minutes to read the entries in the file and post to our production data, and then delete the file. How are you using the UPS connection, "Keyed Import" ? Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Thursday, July 16, 2009 8:20 AM To: U2 Users List Subject: Re: [U2] ODBC to UPS WorldShip ================================ UniVerse ODBC Client Version 4.0.3 Build 7251 February, 2008 ================================ on both PC's We are not SHIMS. We are not Prelude. This may be a lost cause. Perhaps a better way to approach this problem is via an external program talking to the UPS database. --Bill -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, July 15, 2009 8:29 PM To: U2 Users List Subject: Re: [U2] ODBC to UPS WorldShip I am in the process of doing this right now. What version of the ibm odbc driver do you have installed? My var warned me against one version, but they didn't elaborate why. Are you a SHIMS or Prelude shop? -----Original Message----- From: Brutzman, Bill <bi...@hkmetalcraft.com> Sent: Wednesday, July 15, 2009 7:47 PM To: U2 Users List <u2-users@listserver.u2ug.org> Subject: [U2] ODBC to UPS WorldShip Using a Windows PC, I am able to obtain a bona fide ODBC connection to UniVerse... and then import UV data to Excel. However... When I try to connect from United Parcel Service's WorldShip v11, WorldShip hangs up with Windows Task Manager indicating "Not Responding". I had the same bad result on two different PC's... One Vista-Ultimate, one XP-Pro. I am wondering if anyone out there was able to get WorldShip ODBC to work with U2. Suggestions would be appreciated. --Bill _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users