IBM ISERIES SC41-5210-04 - Manual (Page 286)

O
object
DB2 UDB for iSeries program 5
query definition 5
omitting field from report 121
OO (double-byte O) 8
operator
concatenation (||) 60
null value 60
numeric 58
optimization
definition 231
OR condition
specifying selection tests 236
OR connection
record selection test 101
output
database file
defining 154
specifying 145
detailed 145
display 145
form
selecting 145, 237
printer 145, 148
summary only
differences between Query/36 and Query for
iSeries 196
specifying 145
to database file
differences between Query/36 and Query for
iSeries 196
type
selecting 145, 237
Override with Database File (OVRDBF) command 187
overriding
database files 187
spooled output 150
OVRDBF (Override with Database File) command 187
P
packed decimal fields 233
page footing
CCSID (coded character set identifier) 253
defining 154
page heading
CCSID (coded character set identifier) 253
defining 154
performance
designing or changing queries 234
tips and techniques 231
performance tuning
recommendations 241
physical file
definition 5
pictograph
DBCS (double-byte character set) 4
position to prompt 15
practice exercises 199
precision
result fields 190
primary file
definition 238
used in file join operations 43
primary record
select/omit criteria 43
Print key 9
printer
defining printout cover page 152
selecting for query output 145, 148
specifying page heading and footing 153
specifying spooled output override 150
printing
differences between Query/36 and Query for
iSeries 196
display 9
query definition 12, 180
processing option
differences between Query/36 and Query for
iSeries 196
ignoring decimal data error 164
purpose 163
rounding numeric field values 164
specifying 238
processing options
character comparisons 176
collating sequence 176
profile
Query for iSeries 18
programming considerations 187
prompt
description 7
position to
Work with Queries display 15
specifying library name 13
specifying query name 13
subset
Work with Queries display 14
Q
query
defining tips 234
running 169
Query
practice exercises 199
query definition
changing 30
example 211
explanation 173
considerations when changing 176
copying 177
copying before changing 173
creating
advanced example 215
example 206
Work with Queries display 27
Define the Query display 28
definition 5
deleting 178
274 Query for iSeries Use V5R2