re: alphabetic header file

["Al Barsa, Jr." <barsa2@xxxxxxx>]

At 12:18 PM 4/5/98 -0400, you wrote:
>I think there may be a better way, so I am asking.
>
>Lets say I have a name and address header file where the records include
>these five names:
>
>
>Adams Brewery, Inc.
>
>J. A. Adams & Company, Inc.
>
>Bruce Adams
>
>Bruce Adams, Jr.
>
>Adam & Bruce Bagels & Buns
>
>
>Now, I want one of the logical files over that physical file to provide
>alphabetic order, using phone book rules of alphabetization.  What
>algorithms make sense and are useful and efficient?

It's not that simple.  We use a trigger program on the physical file, which
propagates 'lookup keys' into a file for lookup.  The lookup file actually
consists of two files.

The physical file is keyed by customer number and contains the lookup word
(i.e.:  ADAMS, BREWREY, etc.) with all of the lookup words converted to
upper case.  The logic in the prohram is smart enough to eliminate words
like COMPANY or INC.

Then there is a logical file keyed by the lookword, which also contains the
customer number.

Al



Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting, LLC.  
400 > 390

Phone:  914-251-9400
Fax:    914-251-9406





Private mail should be sent to barsa@ibm.net
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---