× 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.



To sort, all you need to do is specify a table on the ALTSEQ in a logical
file:

     A*ARCUS - CUSTOMER MASTER FILE                              
     A*                                                          
     A                                      ALTSEQ(*LIBL/ALTTBL) 
     A          R CUS                       PFILE(ARCUS)         
     A*                                                          
     A          K CUSLNM                                         
     A          K CUSFNM                                         
     A          K CUSNO                                          

Putting an upper-case only field in the file just to sort by is not
necessary.

Francis Lapeyre
IS Dept. Programmer/Analyst
Stewart Enterprises, Inc.
E-mail: flapeyre@xxxxxxxx 


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Wayne McAlpine
Sent: Wednesday, August 30, 2006 3:35 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Converting names & street names

Another case for including both sort name and display name fields in the 
file.

Alan Shore wrote:
Thanks for your reply Tommy, but the main problem I am going to have is
with the names like
O'Donnell
McGuyver
etc
where the name contains more than one upper case character.
When I worked on a mainframe, using COBOL, we had to do the same thing in
converting from upper case to mixed case, and we ended up with literally
THOUSANDS of names like these that did not fit a straight conversion.
These
we had to place in a special file to cross-reference them to how they
should be printed on a letter.
Now this was more years ago than I care to remember, and the mainframe
(and
the bank) no longer exist.
I admit, I AM being lazy, and if I had to, I could go through the routine
of re-creating this special file on the AS/400 (or i5, i-series or
whatever
its now called) but if someone already has this available (and is willing
to share) ............

Thanks


Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx

midrange-l-bounces@xxxxxxxxxxxx wrote on 08/30/2006 03:57:17 PM:

I have run this for a long time so I'm not sure what state it's
in....but it should be a good start.


Thanks,
Tommy Holden


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Wednesday, August 30, 2006 2:53 PM
To: Midrange Systems Technical Discussion
Subject: Converting names & street names

Afternoon all,
we hold our customer name and address in upper case. We want to create
letters to these customers, but we want to convert the name and address
to
mixed case, so that the name looks like

SMITH             converts to       Smith
which is fairly straight forward, however,
O'DONELL    converts to       O'Donell
MCGUYVER    converts to McGuyver
plus others could provide problems.
My question is :-
does anyone have/know of a routine and/or 3rd party vendor that would
handle the conversion of names and addresses from upper case to mixed
case?

Thanks in advance



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
--
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.

[attachment "cvtchar.txt" deleted by Alan Shore/NBTY] --
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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.