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

 

1 2 3 4 5

ODOBSZ

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

Page 237
Image 237
IBM SC41-5210-04 manual 3 4