This tip presents an alternative to Tim Granatir's method of keying a file based on mixed case fields.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.