Re: String Searching

Yes - that's the way.
Also remember if your RPG do something more complicated than SETLL you
might need to define an alternate seq. for that program.

You will find, that QSYSTRNTBL will not (I think) xlate your accented
chars correctly. You can easily create your own one. It might be usefull
to 'retrieve' the source of QSYSTRNTBL: Create the file described below.
Do a DSPFD and use copy/paste into QTBLSRC

Henrik

----------
> Fra: Rob Berendt <rob@dekko.com>
> Til: MIDRANGE-L@midrange.com
> Emne: Re: String Searching
> Dato: 27. maj 1999 21:46
> 
> From the DDS manual:
>   00010A                                      ALTSEQ(TABLELIB/TABLE1)
>   00020A          R RECORD1                   PFILE (PF1)
>   00030A             :
>   00040A             :
>   00050A             :
>   00060A            NAME          20
>   00070A             :
>   00080A             :
>   00090A          K NAME
> 
> Only instead of TABLELIB/TABLE1 use QSYSTRNTBL and it will build the 
> keys as if they were stored in the file all uppercase.  Great for 
> logical files.
> 
> 
> 
> 
> 
> doug@netserv.ouac.on.ca on 05/27/99 02:13:51 PM
> Please respond to MIDRANGE-L@midrange.com@Internet
> To:   midrange-l@midrange.com@Internet
> cc:    
> Fax to:       
> Subject:      String Searching
> 
> Hi,
> 
> We stores people's names in our database in mixed upper-/lower- case,
and mixed 
> english/french characters.  We've gradually been experiencing little
problems now with 
> name searches, alphabetically sorted lists, etc., since the characters
get sorted  {a,b, 
> ..., z, A, B, ..., Z} and english letters like "e" and "a" not being
equal to "e`" and "a`"  
> (i.e. letter with french accent above).  So, names like "de Silva" do
not sort with the 
> rest of the "D's", "von ..." do not sort with the rest of the "V's",
etc. We've tossed 
> around a couple of solutions like:
> 
> 1) storing another version of the name fields in strict
upper-case/english only, and 
> using that for searching, then displaying the other version to users
> 
> 2) building temporary files containing the same as in 1) as needed
> 
> 3) translating the data in the input records and search arguments on
the fly as they're 
> read from the file (which may mean reading the complete file in some
applications, or 
> at least more reads than just doing a basic "<search argument> SETLL
<file> and 
> <search argument> READE <file>" (we're RPG users <grin>). 
> 
> Does anyone have any other tricks or solutions that you'd be willing to
share?
> 
> Thanks in advance,
> Doug
>
--------------------------------------------------------------------------

>   Doug Holmes
>   Senior Programmer
>   Ontario Universities' Application Centre
>   P.O. Box 1328, 650 Woodlawn Road West
>   Guelph ON, CANADA  N1H 7P4
>   TELEPHONE: (519)823-1940, x 224   FAX: (519)823-5232
>   www.ouac.on.ca
>
--------------------------------------------------------------------------

> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@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
> +---
> 
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@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
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@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
+---