IBM SC41-5210-04 manual Odobtp List, Library Object, Attribute Size, Clp, Qgpl File Dktf

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