LCE270 - Top-10 and Bottom-10 Query
What I Should Know
- By using a combination of Sort options and Maximum records, I can create a Top-10 style query. To do this, I need to ensure that the data is on the host and not at the local PC. To ensure that the data is sorted on the host, I can either create a join query or use the Like operator with an All Values prompt, and use the Output Options command to set the Maximum records to the number I require.
- I can force data to be sorted on the server by:
- Using a Join query. (A join query follows a different sort algorithm from a query over a single file.)
- Using an 'is like' condition on any of the fields in my query. (That is, the 'is like' condition with 'All values' (or 'is like *'.)
- Using a condition on a non-key field (except the 'is equal' condition) with no virtual fields in my query.
- Sorting on the IBM i happens in EBCDIC sequence (letters before numbers: A,B,Z,1).
- Sorting on the PC happens in ASCII or ANSI sequence (numbers before letters: 1,2,9,A).