Re: Query/400 Upper-Lower Case

[Patrick L Archibald <Patrick.Archibald@xxxxxxxxxxxxx>]

I don't know of a way with the RUNQRY command but you can with the 
OPNQRYF command.

Use the  SRTSEQ(*LANGIDSHR) on the OPNQRYF command to ignore case on 
your record selection.

If you create a query via the WRKQRY command you can do several things 
with the collating sequence. One of which is specify a translation table 
like QUSRSYS/QCASE256 which you can then specify all upper case letters 
in your record selection.

Thanx, PLA

Shannon ODonnell wrote:

> This question came up today, and I'm surprised that after all these years of
> programming, that this is something I've not had a reason to investigate
> before.  But...  Using Query/400  (i.e., Runqry *n MyLib/MyFile
> RCDSLT(*YES))  on the query selection...is it possible to search for both
> upper and lower case letters in a single pass?  For example,  if I want to
> find a record with RNAME='Johnson'  and I enter  RNAME LIKE '%JOHNSON%'.....
> Is there a way to specify that I want to search for both upper and lower
> case letters so that it will find 'Johnson'  and  'JOHNson', etc...?
>
> Just curious...
>
> Shannon O'Donnell
>
>
>
>
>
>
> --
> 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.
>
>
>
>