|
William, At least in our shop (V5R3), Collating Sequence Option 5 does the trick. Hope this helps, Luis Rodriguez midrange-l-request@xxxxxxxxxxxx wrote:------------------------------ message: 5 date: Thu, 1 Feb 2007 07:47:58 -0800 from: "Willie J. Moore" subject: RE: Query400 Lower to Upper Case Translate table Opt#2 did not work. Still tring to get this working. Thanks for the suggestion. William... -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Mark Allen Sent: Monday, January 29, 2007 2:20 PM To: Midrange Systems Technical Discussion Subject: Re: Query400 Lower to Upper Case Translate table Try option 2 on Collating Sequence (think it says something like Query for English????) On 1/29/07, Willie J. Moore wrote:
Query400 Lower to Upper Case Translate table. I am trying to use the QSYSTRNTBL *TBL in a query. I have added it to the 'Select Collating Sequence' with option #4. I have made sure the table was in QSYS. This looks like it would not require our users to us upper case in their queries. Am I overlooking something? Thanks, William...
Luis Rodriguez IBM Certified Systems Expert eServer i5 iSeries Technical Solutions --------------------------------- Access over 1 million songs - Yahoo! Music Unlimited.
As an Amazon Associate we earn from qualifying purchases.
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.