HP QUERY, Reference Manual, Page: 147 / 280

REPORT
5405T14F 9/11/85
4397D13P 3/02/85
3739A14F 12/15/85
6650D22S 12/05/85
6650D22S 12/14/85
6650D22S 12/15/85
REPORT - SORT ST A TEMENTS
The sort statement sp ecies data items whose v alues are used to sort data en tries when
they are prin ted in the rep ort. It also denes con trol break lev els for use b y group and total
statements in the rep ort.
Syntax
S
2
level
3
, data item name ,
ASC
DES
F or example:
S3,BADGE#,ASC
Where level = 3 and data item name = BADGE#
S,L-NAME
Where data item name = L-NAME
P arameters
level is an in teger from 1 to 10. A sort statement with level greater than 1 m ust b e
accompanied b y sort statements con taining all low er lev el n um b ers. That is,
if S3 app ears in the rep ort, S2 and S1 m ust also app ear in it. Y ou need not
sp ecify a lev el. In this case, the sort statement sorts but do es not dene a
con trol break.
data item
name
is the name of a simple data item or a comp ound data item with an optional
subscript parameter, that is con tained in data en tries selected b y the last
retriev al command. If y ou used a FIND CHAIN to retrieve en tries, use a
master data item in the sort statement. It can also b e qualied with the data
base and data set to whic h it b elongs. The form is:
2
data b ase name:
3
data set name.
dummy data set name
data item name
2
( subscript )
3
dummy data set name is a temp orary data set name used in m ultiple data set
access. (Refer to the JOIN command).
subscript is a n um b er that indicates whic h sub-item y ou w an t to access.
Subscript is en tered in paren thesis and m ust b e an in teger >= 1, and <= the
n um b er of sub-items dened for the comp ound item. QUER Y will default to
the rst sub-item if no subscript is sp ecied.
ASC indicates that the data item v alues are to b e ordered in ascending order. If
y ou do not sp ecify ASC or DES, the default order is ASC.
QUERY/V COMMANDS 3-111