IBM SC41-5210-04 manual Part 3. Advanced information about Query for iSeries

Models: SC41-5210-04

1 294
Download 294 pages 6.42 Kb
Page 8
Image 8

Record on one page in Query for iSeries reports

.

.

.

147

Displaying wrapping widths in Query for iSeries reports

.

.

.

147

Defining output to the printer in Query for iSeries reports

.

.

.

148

Defining output of Query for iSeries reports to a database file

.

.

.

154

Using an existing output file definition in Query for iSeries reports

.

.

.

155

Building a new output file definition in Query for iSeries reports

.

.

.

156

Using an output database file created by Query for iSeries

.

.

.

161

Chapter 14. Specifying Query for iSeries processing options

.

.

.

163

Purpose of Query for iSeries processing options

.

.

.

163

Rounding numeric field values during Query for iSeries processing

.

.

.

164

Ignoring decimal data errors during Query for iSeries processing

.

.

.

164

Ignoring character substitution warnings during Query for iSeries processing

.

.

.

165

Using collating sequence for all character comparisons during Query for iSeries processing

.

.

.

165

Chapter 15. Exiting and running a Query for iSeries query

.

.

.

167

Ending a Query for iSeries query definition

.

.

.

167

Saving a Query for iSeries query definition

.

.

.

167

Running a Query for iSeries query

.

.

.

169

Using function key F5 when running a Query for iSeries query

.

.

.

169

Running a Query for iSeries query from the Query for iSeries menu

.

.

.

169

Running a Query for iSeries query from the Exit This Query display

.

.

.

169

Running a Query for iSeries query from the Work with Queries display

.

.

.

170

Running a Query for iSeries query using the RUNQRY command

.

.

.

171

Chapter 16. Working with Query for iSeries query definitions

.

.

.

173

Changing a Query for iSeries query definition

.

.

.

173

Starting changes by copying a Query for iSeries query definition

.

.

.

173

Changes you can make to a Query for iSeries query

.

.

.

173

Considerations for changing Query for iSeries queries

.

.

.

176

Copying a Query for iSeries query definition

.

.

.

177

Renaming a Query for iSeries query definition

.

.

.

178

Deleting a Query for iSeries query definition

.

.

.

178

Displaying a Query for iSeries query definition

.

.

.

179

Printing a Query for iSeries query definition

.

.

.

180

Information printed for a Query for iSeries query definition

.

.

.

181

Example of printed record format information for a Query for iSeries query definition . . .

.

.

.

182

Part 3. Advanced information about Query for iSeries

.

 

185

Chapter 17. Additional information about Query for iSeries for programmers

.

.

187

Files with different record formats in Query for iSeries

.

.

187

File sharing considerations in Query for iSeries

.

.

187

Overriding database files in Query for iSeries

.

.

187

DBCS considerations when defining result fields in Query for iSeries

.

.

187

Joining files in Query for iSeries

.

.

188

Using *ALL in Query for iSeries

.

.

188

Using fields other than sort fields for report breaks in Query for iSeries

.

.

188

Result field length and decimal positions in Query for iSeries

.

.

188

Tips for dealing with presentation length and decimal positions in Query for iSeries. . . . . . . 188

Length and decimal positions used for internal numeric calculations in Query for iSeries . . . . . 189

Example: Increasing the decimal precision for result fields in Query for iSeries

. . . . . .

.

.

190

Selecting records (ignoring field case) in Query for iSeries

. . . . . .

.

.

191

 

 

 

 

 

Part 4. Appendixes

. . . . . .

.

.

193

viQuery for iSeries Use V5R2

Page 8
Image 8
IBM SC41-5210-04 Part 3. Advanced information about Query for iSeries, Specifying Query for iSeries processing options