IBM SC41-5210-04 manual Selecting sort fields in Query for iSeries

Models: SC41-5210-04

1 294
Download 294 pages 6.42 Kb
Page 7
Image 7

Letting Query for iSeries select records

. . . . . . . . .

.

.

.

91

Selecting the records you want in Query for iSeries

. . . . . . . . .

.

.

.

91

Comparison fields in Query for iSeries

. . . . . . . . .

.

.

.

92

Comparison values in Query for iSeries

. . . . . . . . .

.

.

.

93

Comparison tests in Query for iSeries

. . . . . . . . .

.

.

.

95

Using more than one comparison test in Query for iSeries

. . .

.

.

101

Adding and removing comparisons in Query for iSeries

. . .

.

.

103

Chapter 8. Selecting sort fields in Query for iSeries

. . .

.

.

105

Letting Query for iSeries determine the order of records for you

. . .

.

.

105

Selecting the sort fields you want to use in Query for iSeries

. . .

.

.

105

Additional sort considerations in Query for iSeries

. . .

.

.

108

Chapter 9. Selecting a collating sequence in Query for iSeries

. . .

.

.

111

Letting Query for iSeries select a collating sequence

. . .

.

.

111

Setting your default collating sequence in Query for iSeries

. . .

.

.

111

Purpose of a collating sequence in Query for iSeries

. . .

.

.

111

Collating sequence and CCSIDs in Query for iSeries

. . .

.

.

112

How a collating sequence affects Query for iSeries

. . .

.

.

112

Selecting a Query for iSeries collating sequence

. . .

.

.

113

Using the hexadecimal collating sequence in Query for iSeries

. . .

.

.

113

Using the language collating sequence for your country in Query for iSeries . . . .

. . .

.

.

114

Defining your own collating sequence in Query for iSeries

. . .

.

.

115

Selecting a translation table in Query for iSeries

. . .

.

.

116

Selecting a system sort sequence in Query for iSeries

. . .

.

.

117

Chapter 10. Specifying report column formatting in Query for iSeries

. . .

.

.

119

Formatting the columns of the Query for iSeriesquery report

. . .

.

.

119

Column spacing in Query for iSeries reports

. . .

.

.

119

Column headings in Query for iSeries reports

. . .

.

.

119

Length and decimal positions in Query for iSeries reports

. . .

.

.

120

Omitting fields from a Query for iSeries report

. . .

.

.

121

Editing numeric fields in Query for iSeries reports

. . .

.

.

122

Defining numeric field editing in Query for iSeries reports

. . .

.

.

122

Describing numeric field editing in Query for iSeries reports

. . .

.

.

124

Describing date/time field editing display in Query for iSeries reports

. . .

.

.

127

Specifying an edit code in Query for iSeries reports

. . .

.

.

129

Specifying edit words

. . .

.

.

131

Chapter 11. Specifying report summary functions in Query for iSeries reports . .

. . .

.

.

135

Types of summary functions in Query for iSeries reports

. . .

.

.

135

Summarizing columns in Query for iSeries reports

. . .

.

.

137

Location of column summary values in Query for iSeries reports

. . .

.

.

137

Chapter 12. Defining Query for iSeries report breaks

. . .

.

.

139

Defining a Query for iSeries report break

. . .

.

.

139

Defining report break formatting in Query for iSeries reports

. . .

.

.

143

Skip to new page in Query for iSeries reports

. . .

.

.

143

Suppress summaries in Query for iSeries reports

. . .

.

.

143

Break text in Query for iSeries reports

. . .

.

.

144

Chapter 13. Selecting output type and output form in Query for iSeries reports . .

. . .

.

.

145

Selecting the output type and form you want in Query for iSeries reports

. . .

.

.

145

Form of output of Query for iSeries reports

. . .

.

.

146

Line wrapping in Query for iSeries reports

. . .

.

.

146

Wrapping width in Query for iSeries reports

. . .

.

.

147

Contents v

Page 7
Image 7
IBM SC41-5210-04 manual Selecting sort fields in Query for iSeries, Selecting a collating sequence in Query for iSeries