IBM ISERIES SC41-5210-04 User Manual

Page 239

Advertising
background image

Format Report Break

Break level . . . . . . . :

1

Type choices, press Enter.

(Type &field in text to have break values inserted.)

Skip to new page . . . . .

N

Y=Yes, N=No

Suppress summaries . . . .

N

Y=Yes, N=No

Break text . . . . . . . .

Break text for object type

Level Field

1

ODOBTP

F3=Exit

F5=Report

F10=Process/previous

F12=Cancel

F13=Layout

F18=Files

F23=Long comment

Press the Enter key.

You are finished with all of the definition steps that you selected earlier, so the Define the Query
display appears again. (The definition steps you selected earlier are now indicated with a > symbol to
the left of them.)

Define the Query

Query . . . . . . :

QNAME

Option . . . . . :

CREATE

Library . . . . :

YOURLIB

CCSID . . . . . . :

37

Type options, press Enter. Press F21 to select all.

1=Select

Opt

Query Definition Option

> Specify file selections

Define result fields

> Select and sequence fields

> Select records

> Select sort fields

Select collating sequence

> Specify report column formatting

> Select report summary functions

> Define report breaks

Select output type and output form

Specify processing options

F3=Exit

F5=Report

F12=Cancel

F13=Layout

F18=Files

F21=Select all

Select options, or press F3 to save or run the query.

14. Now display your report by pressing F5 (Report). The Display Report display appears showing your

finished query report. (The information you see on your display depends on the objects that are
currently in QGPL on your system. What you see may not match what is shown in the display that
follows.)

Appendix B. Practice exercise for Query for iSeries query

227

Advertising