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

dividing by zero (0)
example 83
DLTQRY (Delete Query) command 11, 178
double-byte character set (DBCS)
bracket characters 9
character constant
shift-in character 60
shift-out character 60
data representation 8
pictograph 4
shift-in character 60
shift-out character 60
sorting character data 111
space requirements 9
symbolic characters 4
duration
date 73
labeled 73
time 73
timestamp 74
E
edit code
modifier 131
numeric fields 129
specifying 129
edit word
different CCSIDs 132
numeric field 131
specifying 131
editing numeric field
defining 122
describing editing
currency symbol 126
date/time field 127
date/time separator 128
decimal point 125
negative sign 125
replacing leading zero 127
thousands separator 125
specifying edit code 129
specifying edit word 131
EE (double-byte E) 8
ending query definition 167
entering data 203
EQ (equal) comparison test 95, 96, 165
error
handling 18
ignoring in numeric field 164
Specify File Selections display 36
EUR (IBM European standard)
date and time 67
example
changing query definition 211
code page 114
connecting record selection test 101
creating database file 203
creating query definition 206, 215
defining result field 86
IDDU definition 199
example (continued)
running query 206
selecting and sequencing field 88
selecting sort field 106
exercise
Query 199
Exit This Query display 167, 169
exiting
Query for iSeries 7, 167
expression
character
definition 58
considerations when creating 83
creating 83
date
definition 58
date data type 68
numeric
definition 58
result field
character 60
creating 83
numeric 59
spanning lines 84
time
definition 59
time data type 68
timestamp
definition 59
timestamp data type 68
F
field
character
differences between Query/36 and Query for
iSeries 196
using result fields 60
comparison 92
date
expressions 66
using result fields 66
DBCS 4, 45
brackets 9
Display Report Layout display 8
expressions 60
field naming convention 4
length(graphic) 120
LIKE comparison test 99
migration(graphic) 241
NLIKE (not like) comparison test 99
printed record format 182
rules for join tests 45
rules for join tests(graphic) 45
selecting records 93
shift-out and shift-in characters 9
definition 3
editing
defining numeric 122
describing numeric 124
floating-point 8
Index 269