Another way to index mixed case fields

This tip presents an alternative to Tim Granatir's method of keying a file based on mixed case fields.

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):

ALTSEQ(QSYSTRNTBL)

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.


This was last published in February 2001

Dig Deeper on RPG iSeries programming

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close