Difference between revisions of "CASE in Query"
From MidrangeWiki
(before fancy symbols) |
|||
| Line 3: | Line 3: | ||
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. | 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. | + | 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. | + | 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'''''. | ||
Revision as of 04:30, 28 May 2005
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.
