RE: Query/400 Upper-Lower Case

["Shannon ODonnell" <sodonnell@xxxxxxxxxxxxxxxxx>]

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.