Filter
Top Products
Select and Sequence Fields
Type sequence number (0-9999) for the names of up to 500 fields to
appear in the report, press Enter.
Seq Field Seq Field Seq Field
ODDCEN ODCCEN ODSV02
ODDDAT ODCDAT ODSV03
ODDTIM ODCTIM ODSV04
ODLBNM ODOBOW ODSV05
ODOBNM ODSCEN ODSV06
ODOBTP ODSDAT ODSV07
ODOBAT ODSTIM ODSV08
ODOBFR ODSCMD ODSV09
ODOBSZ ODSSZE ODSV10
ODOBTX ODSSLT ODSVMR
ODOBLK ODSDEV ODRCEN
ODOBDM ODSV01 ODRDAT
More...
F3=Exit F5=Report F11=Display text F12=Cancel
F13=Layout F20=Renumber F21=Select all F24=More keys
If your display is in multiple-column format (that is, if the Text, Len, and Dec columns are not shown),
press F11 (Display text) to show some additional information about the fields in the list. Select the
fields ODLBNM, ODOBTP, ODOBAT, ODOBSZ, and ODOBTX by typing the numbers 1 through 5 to the left of
them as shown below. The fields you select are the fields that will appear in your query report, in the
order that you specify (ODLBNM will appear first, followed by ODOBPT, and so on).
Note: You must select fields that you plan to sort on.
Select and Sequence Fields
Type sequence number (0-9999) for the names of up to 500 fields to
appear in the report, press Enter.
Seq Field Text Len Dec
ODDCEN DISPLAY CENTURY 1
ODDDAT Display date: Format- MMDDYY 6 x
ODDTIM DISPLAY TIME 6
1 ODLBNM LIBRARY 10
ODOBNM OBJECT 10
2 ODOBTP OBJECT TYPE 8
3 ODOBAT OBJECT ATTRIBUTE 10
ODOBFR Storage freed: 0-Not freed,1-Freed 1
4 ODOBSZ OBJECT SIZE 10 0
5 ODOBTX TEXT DESCRIPTION 50
ODOBLK Object locked: 0-Not locked,1-Locked 1
ODOBDM Object damaged: 0-Not damaged,1-Damaged 1
More...
F3=Exit F5=Report F11=Display names only F12=Cancel
F13=Layout F20=Renumber F21=Select all F24=More keys
Press the Enter key. Query rearranges the fields on the display so that the fields you selected are
shown at the top of the list in the order that you specified. The message Press Enter to confirm. is
also shown.
Appendix B. Practice exercise for Query for iSeries query 219