|
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.
--
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.