Re: U.S. and Canadian Postal Code (ZIPcode) validation for the IBM i

[Jim Essinger <dilbernator@xxxxxxxxx>]

I used Works Right software for zip code validation at a previous company.
I was very pleased with their service and support.  We don't need that
function here, or I would recommend them to the boss.

They can be found at www.*worksright*.com.

A former satisfied customer.

Jim

On Fri, Dec 11, 2009 at 9:53 AM, <elehti@xxxxxxxxxxxxxxxxxx> wrote:

> "What do IBM i users do for Postal Code and ZIP code validation of
> transactions on the i?
>
> Do you have a recommendation on a U.S. and Canadian Postal Code
> (ZIPcode) database for the IBM i?
> Other than Worksright.com?
>
> Last year we purchased from ZipInfo.com a database of U.S. and Canadian
> Postal Codes (ZIP codes) for less than $200.
> It was a simple text file in comma-separated value format with almost a
> million rows.
> Uploaded it to our IBM i into DB2 and created a table.
> Added additional columns for data of interest to Ameristar (our sales
> rep names, etc.)
>
> Now we want to refresh our database with the latest corrections and
> updates from the U.S. postal service and Canada.
> As I consider the challenge of updating our custom database file with
> additions/deletions/changes provided by ZipInfo.com in .CSV format, I
> ask myself,
>
> "What do other IBM i customers do for Postal Code and ZIP code
> validation?
> How do you keep your ZIP code database current and up-to-date?
> Eric Lehti
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.