Filter
Top Products
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