Alfred,
I haven't done this specifically (our rate calculator was written in house) but when I need to expose this type of functionality to either Java or systems running off-box, I typically create an external stored procedure to do it. Depending upon how the parameters are passed in, you may be able to get by with just defining the SQL procedure but if you pass in data structures, you'll probably want to write a helper program to make the calls easier to make.
Matt
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Alfredo Delgado
Sent: Monday, January 14, 2008 9:40 AM
To: web400@xxxxxxxxxxxx
Subject: [WEB400] Varsity Shipping Rate Optimizer
Good morning,
We're a JDE shop and we utilize a shipping rate optimizer from Varsity
Logistics that suggests the best/cheapest carriers for orders. Order items
can range from small and expensive to large and cheap so whether we use a
freight company vs. ground vs. air is important.
Has anyone on the list had experience interfacing with Varsity when creating
an e-commerce order process? For established customers it's possible to have
esoteric shipping data in their record but for a retail customer I'd really
be looking to just provide an origin zip code, a destination zip code, and
some information about the items being shipped. In either case cleanly
obtaining the output to format for a user would be necessary.
If you know of an add-on product that can meet these requirements I'm open
to those suggestions, too.
Thanks,
Alfred
--
Alfredo Delgado / Web Development
6800 Broken Sound Pkwy; Suite 150
Boca Raton, Florida 33487
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/web400.
midrange.com
