RE: Query/400 Upper-Lower Case

[rob@xxxxxxxxx]

Most people using the RUNQRY command bury it in a program.  Simply convert 
the search text to upper case in the program prior to passing it to the 
RUNQRY command.  If, however, the file data may be mixed case it gets a 
bit trickier.

How's about converting it to a query management query and using the UPPER 
function?  No 57xx-ST1 is required for your system just to do this.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Shannon ODonnell" <sodonnell@xxxxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
06/11/2004 09:54 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

Fax to

Subject
RE: Query/400 Upper-Lower Case






I should have been more specific.  My fault.  What I meant was, is there a
way to do the upper/lower case thing using ONLY the RUNQRY *N MYLIB/MYFILE
RCDSLT(*YES) command? 

Thanks for the tips on how to do this with the full Query/400 tool though. 
I
did not know that either and it will come in very handy sometime, I'm 
sure! 


Shannon O'Donnell

 


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Lance Gillespie
Sent: Friday, June 11, 2004 9:34 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Query/400 Upper-Lower Case

> 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?

Yes. Use the collation sequence option in the query definition
and change it to  4 (Translation table).  Then use 
QSYSTRNTBL in library  QSYS.
--
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.





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