##EMailNumber 01-WNY-8501419

[jmoreno@xxxxxxxxxxxxxxxx]

phelpswr@alpha.obu.edu wrote on 09/19/97 at 11:31:08



>I have a physical file with a name field containing mixed case
>letters.  I would like to use the name as a key field.  On my
>programs I always provide an input field to position the list.
>User's have a difficult time getting the name keyed in the exact
>upper/lower case to position the list correctly.  What are some ways
>to design a logical file or the application to ignore the case and
>position the list correctly.
>
>Thanks in advance....
---------------------------------------------------------------------------
----------------***********************************************************
********************************

The AS/400 DDS book indicates how to use the keywords ALTSEQ and TRNTBL to
achive what you are looking to do. (use the QSYSTRNTBL Table in QSYS)
Create a new field and use this new field for Key (ndex). Good Luck.


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---