Filter
Top Products
definition (continued)
changing 30, 173
changing (example) 211
copying 177
copying before changing 173
creating 27, 30
creating (example) 206
deleting 179
displaying 179
DLTQRY command 178
information printed 181
migrating restriction 197
naming 27
printing 180
renaming 178
running 8
saving 167
selecting files 33
specifying authority 168
definition display
moving through 30
definition step
description 29
selecting on Define the Query display 28
Delete Query (DLTQRY) command 11, 178
deleting
file selections from a query 36
query definition
DLTQRY command 178
Query for iSeries menu 11
Query menu 178
Work with Queries display 12, 179
descending sequence
sorting records 105
Describe Date/Time Field Editing display 128
Describe Numeric Field Editing display 124
describing
numeric field editing 124
detailed output 145
DFU (data file utility) 4
differences between Query/36 and Query for iSeries
commands 195
maximum length of character fields 195
number of files that can be joined 195
operational
joining files 195
types of joins 195
DIGITS function
argument rules 62
syntax diagram 62
display
Confirm Delete of Queries 179
Copy Queries 177
Create and Select Field Definitions (IDDU) 200, 202
Create Field Definitions (IDDU) 201
Create File Definition (IDDU) 200
Define Collating Sequence 115
Define Database File Output 155
Define Numeric Field Editing 122
Define Printer Output 148
Define Report Breaks 139
display (continued)
Define Result Fields 57
Define Spooled Output 151
Define the Query 28
Describe Date/Time Field Editing 128
Describe Numeric Field Editing 124
Display Date Format 69
Display File Selections 42
Display Join Tests 53
Display Report Layout 8
Exit This Query 167, 169
Fields Missing from File Definition 54
Format Report Break 143
IDDU main (system) menu 199
Select and Sequence Fields 87
Select Collating Sequence 113
Select Definition Type (IDDU) 200
Select File 37
Select Member 40
Select Record Format 41
Select Records 92
Select Report Summary Functions 136
Select Sort Fields 105
Select Translation Table 116
selecting for query output 145
Selecting Output Type and Output Form 146
Specify Cover Page 152
Specify Edit Code 129
Specify Edit Word 131
Specify File Selections 33
Specify How to Join Files 44
Specify Page Headings and Footings 153
Specify Processing Options 163
Specify Report Column Formatting 120
Specify Type of Join 43
System Sort Sequence 118
time format 69
Work with Database Files (IDDU) 203
Work with File Definitions (IDDU) 200, 202
Work with Queries 171
display date and time format
F17 function key 18, 69
Display File Selections display 42
Display Join Tests display 53
Display Report display 8
Display Report Layout display 8
displaying
files selected for a query 41
format
date 17
decimal separator 17
time 17
join tests 53
lists 9
query 249
query definition 12, 179
query output 145
report layout using F13 8
report using F5 8, 169
text about items in a list 15
268 Query for iSeries Use V5R2