FW: OPNQRY Seq with mixed case field

[Charlie Browne <crbrowne@xxxxxxxxxxxxxxxxx>]

Title: FW: OPNQRY Seq with mixed case field

-----Original Message-----
From: Charlie_Massoglia@common.org [mailto:Charlie_Massoglia@common.org]
Sent: Friday, July 13, 2001 1:44 AM
To: crbrowne@cssconsulting.com
Subject: Re: OPNQRY Seq with mixed case field

You can use a combination of MAPFLD and %XLATE as shown below:

   OPNQRYF FILE(YOURFILE) KEYFLD((EMPNAME) (EMPNUM))
                              MAPFLD((EMPNAME '%XLATE(EMPNAME QSYSTRNTBL)'))

I'm in Sydney right now at Interaction Australasia and could not send a response
directly to Midrange-L for some reason.  I'd appreciate your forwarding this
response to Midrange-L in case anyone else runs into the same problem.

Thanks.

----- Original Message -----
From: Charlie Browne
To: 'RPG400-L@midrange.com'
Sent: Thursday, 12 July, 2001 10:09
Subject: OPNQRY Seq with mixed case field

I have a file that contains employee names. So of the names are all upper case
and some are mixed case. I can use QSYSTRAN table to get a LF in the correct
sort sequence, but I am having problems getting OPNQRY to work. Can anyone help
me?

TIA
Charlie Browne