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 first published in February 2001

Dig deeper on RPG iSeries programming

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchEnterpriseLinux

SearchDataCenter

Close