IBM ISERIES SC41-5210-04 User Manual
Page 233
Select Records
Type comparisons, press Enter. Specify OR to start each new group.
Tests: EQ, NE, LE, GE, LT, GT, RANGE, LIST, LIKE, IS, ISNOT...
AND/OR Field
Test
Value (Field, Number, or ’Characters’)
ODOBTP
LIST
’*FILE’ ’*PGM’
Bottom
Field
Text
Len Dec
ODLBNM
LIBRARY
10
ODOBTP
OBJECT TYPE
8
ODOBAT
OBJECT ATTRIBUTE
10
ODOBSZ
OBJECT SIZE
10
0
ODOBTX
TEXT DESCRIPTION
50
More...
F3=Exit
F5=Report
F9=Insert
F11=Display names only
F12=Cancel
F13=Layout
F20=Reorganize
F24=More keys
8. Now display your report by pressing F5 (Report). The Display Report display appears showing your
query report, which is based on the query you have defined up to this point. (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.)
Display Report
Report width . . . . . :
100
Position to line . . . . .
Shift to column . . . . . .
Line
....+....1....+....2....+....3....+....4....+....5....+....6....+....7...
LIBRARY
OBJECT
OBJECT
OBJECT
TEXT DESCRIPTION
TYPE
ATTRIBUTE
SIZE
000001 QGPL
*PGM
CLP
14,336
B & R Example - Page 2
000002 QGPL
*PGM
CLP
16,384
B & R Example - page 2
000003 QGPL
*FILE
PF
8,192
000004 QGPL
*FILE
PF
1,024
Default source data ba
000005 QGPL
*FILE
PF
1,024
Default source data ba
000006 QGPL
*FILE
PF
16,384
Default source data ba
000007 QGPL
*FILE
DKTF
2,560
Default diskette data
000008 QGPL
*FILE
DKTF
2,560
Default source diskett
000009 QGPL
*FILE
PF
1,024
Default source data ba
000010 QGPL
*FILE
PF
140,288
RSTS36FLR COMMAND
000011 QGPL
*FILE
PRTF
2,048
Default spool output p
000012 QGPL
*FILE
PRTF
2,048
Default spool print fi
000013 QGPL
*FILE
PRTF
2,048
Default spool print fi
000014 QGPL
*FILE
PF
38,912
Outfile for DSPOBJD
000015 QGPL
*FILE
PF
16,384
More...
F3=Exit
F12=Cancel
F19=Left
F20=Right
F21=Split
F22=Width 80
On the bottom far right side of the display, the message
More... appears. This means that all of the
report does not fit on the display, so if you want to see all of the report, you can use the page keys or
F20 (Right) and F19 (Left) to page through the report (both left to right and top to bottom). When you
have finished looking at the report, press F3 (Exit) to return to the Select Records display.
Appendix B. Practice exercise for Query for iSeries query
221