IBM SC41-5210-04 manual Heading Ccsid coded character set identifier 253 Defining

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

274Query for iSeries Use V5R2