IBM SC41-5210-04 manual Company Baldue Acctnumber

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
10	COMPANY	____	BALDUE
20	ACCTNUMBER	____	DATELASTPD
30	PASTDUE	____	CURRENTDAT
____	FIRSTNAME	____	YEAR
____	MIDDLEINIT	____	MONTH
____	LASTNAME
____	STREETADDR
____	CITY
____	STATE
____	ZIPCODE
____	TELENUMBER
____	CRLIMIT

			Bottom
F3=Exit	F5=Report	F11=Display text	F12=Cancel
F13=Layout	F20=Renumber	F21=Select all	F24=More keys

You could then select the remaining fields for output on the report by pressing F21 (Select all). Query would then select and supply sequence numbers for the remaining fields in the order that they appeared in the list.

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
10	COMPANY	130	BALDUE
20	ACCTNUMBER	140	DATELASTPD
30	PASTDUE	150	CURRENTDAT
40	FIRSTNAME	160	YEAR
50	MIDDLEINIT	170	MONTH

60LASTNAME

70STREETADDR

80CITY

90STATE

100ZIPCODE

110TELENUMBER

120CRLIMIT

			Bottom
F3=Exit	F5=Report	F11=Display text	F12=Cancel
F13=Layout	F20=Renumber	F21=Select all	F24=More keys

Another way of making your selections is to first specify the same sequence number (a 1, for example) for all of the fields you want to select. Press the Enter key, and Query pulls all of those fields to the top of the list. You can then specify new sequence numbers to arrange the fields in the order you want for your report. This is particularly useful when there are too many fields to appear on a single display.

Query has the ability to show you additional information about the fields in the list area of the display. If only the field names are shown in the list and you press F11, you see the descriptive text, the length, and the decimal positions for the fields. For more information on using F11, see “Using F11 to display additional information about Query for iSeries queries” on page 15. You can also display a long comment (if one exists) for a field (or display the expression defining a result field) by moving the cursor to that field and pressing F23.

Chapter 6. Selecting and sequencing fields in Query for iSeries 89