Re: PDQ: Case insensitive key lookup in LF and/or PF?

Well, there are some vendors that do have upper/;ower versions of a name as
an alpha sort. That may be your best bet, because ALTTL is CCSID sensitive.
The drag is that you'll have to %xlate from lower to upper whenever the
mixed-case field is populated or changed.

Or, you could just remove CHECK(LC) from all the display files ;)

On Nov 13, 2007 9:44 AM, Francis Lapeyre <flapeyre@xxxxxxxxx> wrote:

Specify ALTTBL(Q037) at the file level.


On Nov 13, 2007 9:36 AM, David Gibbs <david@xxxxxxxxxxxx> wrote:

Folks:

I've got a PDQ (Potentially Dumb Question, a TLA I just made up) about
database key access.

We have a need to create key in a file that contains upper & lower case
data ... but when we chain to the file, we want the key to be case
insensitive. Also, this chain needs to be done in multiple CCSID's
(including DBCS).

Originally we were thinking of creating a logical file with a renamed
field & TRNTBL(QSYSTRNTBL) attribute, and making that field the key.
But it occurred to us that the QSYSTRNTBL may not be CCSID aware and, in

order to access all the fields in the file, we have to add each
individual field to the logical.

I was also thinking about giving the key field in the logical file an
alternate collating sequence table, where the table has the hex values
for the upper case letters in the lower case character positions ... but
that would not be CCSID aware.

Our only other idea is to put a duplicate field in the file ... one
field would contain the data in all caps, and would be the key, the
other field would contain the mixed case value for display purposes.
Currently this our best alternative ... and isn't that hard to
implement, because all access to this file is done through a service
program.

Any suggestions on a better way to approach this?

Thanks!

david


--
System i ... for when you can't afford to be out of business
--
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.

--
Francis Lapeyre

Solum potestis prohibere ignes silvarum.