[ |../../index.htm#lansa/lceeng01_0480.htm]
You are here:

Summary

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

[ |../../index.htm#lansa/lceeng01_0480.htm]