We've done Worldship with a live ODBC connection to Unidata for a number of
clients; I would think UV might be similar. To make the unique ID work, we
mapped @ID in Unidata to the box (not shipment) number in Worldship, as each
box is unique. This does create an interesting issue when dealing with
voided boxes, as Worldship always sends INSERTs and they can send the same
ID twice with a void, which causes an INSERT failure. So we have Worldship
insert into a file with a phantom that picks up the transactions and posts
them into the appropriate place, removing the transaction from the file
during the posting. Voids usually don't come right on the heels of a
shipment, so the couple of seconds that a transaction sits in the file
usually doesn't cause any issues.
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
