RE: logical fie with one field in upper case

["Don Tully" <dtully@xxxxxxxxxx>]

Create a logical file listing all of the fields in PF or just desired fields
plus one more field. That one more field uses keyword TRNTBL(QSYSTRNTBL)
That field can be used as needed in an index and the regular mixed case
field is also available.  Here is a partial example of fields in the logical
file.  I usually put the NAMEUC field as the last field in the logical, so
that the first set of fields match the physical.

A            NAME
A            NAMEUC         I      RENAME(NAME)
A                                  TRNTBL(QSYSTRNTBL)

Don Tully
Tully Consulting LLC
920 996-0448


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Fergal O'Flynn
Sent: Tuesday, October 12, 2004 8:48 AM
To: midrange-l@xxxxxxxxxxxx
Subject: logical fie with one field in upper case


I have a physical file where one of the fields is a surname in mixed case.
I want to create a logical view where this field is also available in the
logical file in upper case. Is there a keyword that I can use to do this
for me.

Thanks



__________________________________

Notice of Confidentiality

This transmission contains information that may be confidential and that may
also be privileged. Unless you are the intended recipient of the message (or
authorised to receive it for the intended recipient) you may not copy,
forward, or otherwise use it, or disclose it or its contents to anyone else.
If you have received this transmission in error please notify us immediately
and delete it from your system.

Email: internet.mail@xxxxxxxxxxxxxxxx

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