× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. May 2020

Re: Multiple INCLUDE statements in SQLRPGLE

Pardon my ignorance, Reeve, but why wouldn't a simple table of valid name/zip entries work?  SPS010 could just do a WHERE EXISTS on that table.

On 5/10/2020 1:34 AM, Reeve wrote:
My thanks to all who responded.

The structure of the data is a collection of ZIP codes grouped together and
referred to by a name (key). Lower Manhattan is covered by ZIPs
10004-10007, 10038, and 10280, so that name might be LMANNY. The SP
accepts a ZIP code and candidate name and returns "true" if the ZIP code
submitted is contained within the candidate name. SPS010('LMANNY','10007)
= '1'; SPS010('LMANNY','10008') = '0'. The name is a pure synonym; a
natural name won't work because there are so many weird combinations set up
by the business users.


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.