Filter
Top Products
query definition (continued)
DLTQRY command 11, 178
Query for iSeries Utilities menu 11
Work with Queries display 178
displaying 179
exiting 167
information printed 181
migrating restriction 197
naming 27
naming restrictions
multilingual environment 27
printing 180
Query for iSeries menu
deleting from 11
renaming 178
running 8
saving 167
selecting files 33
selecting from list 10
selecting options 29
specifying authority 168
Query for iSeries
command 11
definition 3
differences from Query/36 195
error 18
exiting 7, 167
how a collating sequence affects 112
introduction
description 3
language sequences 249
menu
getting to 7
using 11
message 18
multiple query tasks 13
profile 18
starting 7, 11
task
choosing 13
description 5
illustration 6
tips and techniques 231
working with 11
query processing 231
R
RANGE (range) comparison test 95, 96
record
definition 3
determining order for query 105
matched 238
selection
CCSID (coded character set identifier) 251
connecting example 101
default 91
test 94, 95
selection test
adding 103
connecting with AND and OR 101
record (continued)
selection test (continued)
DBCS LIKE 99
DBCS NLIKE (not like) 99
EQ (equal) 95, 96
GE (greater than or equal) 95, 96
GT (greater than) 95, 96
IS (is) 95
ISNOT (is not) 95
LE (less than or equal) 95, 96
LIKE (like) 95, 98
LIST (list) 95, 97
LT (less than) 95, 96
NE (not equal) 95, 96
NLIKE (not like) 95, 98
NLIST (not list) 95
RANGE (range) 95, 96
removing 103
unmatched 239, 241
record format 187
definition 3
printing example 182
selecting for file selection
Select Record Format display 40
Specify File Selections display 35
record selection
CCSID (coded character set identifier) 253
record selection test
definition 231
OR condition 236
performance recommendations 235
related printed information 259
relational database file 5
removing
record selection test (comparison) 103
result field 86
renaming query definition 178
report
break
case sensitivity 142
CCSID (coded character set identifier) 253
defining 139
definition 139
differences between Query/36 and Query for
iSeries 196
example of defining 140
fields other than sort fields 188
formatting 143
levels 139
text 144
column formatting
heading 119
length and decimal position for field 120
spacing 119
field 54
omitting 121
missing 54
output
database file 145, 154
display 145
printer 145, 148
Index 275