Filter
Top Products
Select Sort Fields
Type sort priority (0-999) and A (Ascending) or D (Descending) for
the names of up to 32 fields, press Enter.
Sort
Prty A/D Field Text Len Dec
1 A ODOBTP OBJECT TYPE 8
2 A ODOBSZ OBJECT SIZE 10 0
ODLBNM LIBRARY 10
ODOBAT OBJECT ATTRIBUTE 10
ODOBTX TEXT DESCRIPTION 50
Bottom
F3=Exit F5=Report F11=Display names only F12=Cancel
F13=Layout F18=Files F20=Renumber F24=More keys
Press Enter to confirm.
Press the Enter key again.
10. The next display is the Specify Report Column Formatting display. It is here that you specify column
spacing, column headings, and other report formatting options.
Specify Report Column Formatting
Type information, press Enter.
Column headings: *NONE, aligned text lines
Column
Field Spacing Column Headings Len Dec Edit
ODLBNM 0 LIBRARY 10
ODOBTP 2 OBJECT 8
TYPE
ODOBAT 2 OBJECT 10
ATTRIBUTE
More...
F3=Exit F5=Report F10=Process/previous F12=Cancel
F13=Layout F16=Edit F18=Files F23=Long comment
Query supplies much of this information for you. Change the column heading for the ODLBNM field so
that it reads NAME OF LIBRARY instead of LIBRARY.
Appendix B. Practice exercise for Query for iSeries query 223