Filter
Top Products
Select Report Summary Functions
Type options, press Enter.
1=Total 2=Average 3=Minimum 4=Maximum 5=Count
---Options--- Field Text Len Dec
ODLBNM LIBRARY 10
ODOBTP OBJECT TYPE 8
ODOBAT OBJECT ATTRIBUTE 10
12345ODOBSZ OBJECT SIZE 10 0
ODOBTX TEXT DESCRIPTION 50
Bottom
F3=Exit F5=Report F10=Process/previous F11=Display text only
F12=Cancel F13=Layout F18=Files F23=Long comment
Press the Enter key.
12. The next display to appear is the Define Report Breaks display. On this display you specify which
fields you want used as break fields. Report breaks are used to break the report into groups of
records each time the value of the report break field changes.
Define Report Breaks
Type break level (1-6) for up to 9 field names, press Enter.
(Use as many fields as needed for each break level.)
Break Sort
Level Prty Field Text Len Dec
ODLBNM LIBRARY 10
10 ODOBTP OBJECT TYPE 8
ODOBAT OBJECT ATTRIBUTE 10
20 ODOBSZ OBJECT SIZE 10 0
ODOBTX TEXT DESCRIPTION 50
Bottom
F3=Exit F5=Report F10=Process/previous F11=Display names only
F12=Cancel F13=Layout F18=Files F23=Long comment
Specify break level 1 for the field named ODOBTP by typing a 1 to the left of it in the Break Level
column.
Appendix B. Practice exercise for Query for iSeries query 225