This tip presents an alternative to Tim Granatir's method of keying a file based on mixed case fields.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
Mr Granatir's technique for indexing mixed case files would definitely work, but unless one needs to process the mixed case information as an uppercase data field, there is another technique that is perhaps easier.
Simply add the following File Level keyword to the physical or logical file which specifies the mixed case field(s) as the key field(s):
This keyword does not change the data fields in any way. It simply causes the access path of the file to be sequenced as if the key field(s) were all uppercase. The Key-field Level keyword NOALTSEQ can then be specified for any field(s) in a composite key for which the alternate sequence should not be used.