CASE in Query

This is about CASE as in Upper or LOWER CASE.

Sometimes we have data in fields with upper and lower case, and we want to ignore the case when it comes to accessing or sequencing the data.

In WRKQRY main definition options, select # 6 Collating Sequence, then on the next panel, select System Sort Sequence. Leave the 2 lines on bottom blank & press enter.

This gets us to a new screen defaulted to *JOBRUN on bottom and we put option 3 Shared on the field up top.

• JOBRUN is the basis of SORT and LANGUAGE. The above combination of selections means CASE can be ignored for all Query criteria.

On WRKQRY main definition options, select bottom Processing Options. First screen is Specify Processing Options.