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

Page 235
Image 235
IBM SC41-5210-04 manual Odlbnm Library Odobtp Object Type Odobat Attribute