IBM @server iSeries, User Manual

Page: 279 / 294

date, time, and timestamp field (continued)
migrating
N to N-1 241
date, time, and timestamp value
average summary function 136
comparing to null 96
IS, ISNOT test 96
total summary function 135
date/time field
editing 127
separator 128
DAY function
argument rules 75
syntax diagram 75
DAYS function
argument rules 76
syntax diagram 76
DB2 UDB for iSeries program
relational database terms
file 5
relationship to OS/400 terms 5
DB2 UDB for iSeries views 237
DBCS (double-byte character set)
bracket characters 9
character constant
shift-in character 60
shift-out character 60
defining result fields
considerations 187
Display Report Layout display 8
LIKE comparison test 99
NLIKE (not like) comparison test 99
pictograph 4
rules for join tests 45
shift-in character 60
shift-out character 60
sorting character data 111
space requirements 9
symbolic characters 4
DBCS (double-byte Character set)
data representation 8
DBCS-either field 8
DBCS-graphic field 9, 45
character constant
requirements 60
concatenation
limitations 60
LIKE, NLIKE pattern
special characters 100
release restrictions 241
DBCS-only field 8
DBCS-open field 8
LIKE, NLIKE pattern
special characters 100
DDS (data description specifications)
introduction 5
Dec column
data type
E 45, 182
G 45
J 45, 182
Dec column (continued)
data type (continued)
L 182
O 45, 182
T 182
V 182
Z 182
Dec field
code
E 121
J 121
L 121
O 121
T 121
V 121
Z 121
decimal
data error
migration from System/36 234
processing 238
point edited numeric fields 125
position
fields in a report 120
for result field 188
result field 85
decimal data
differences between Query/36 and Query for
iSeries 196
decimal data error
ignoring 164
decimal positions and length
used for internal numeric calculations 189
decimal precision for result fields 190
decimal separator
displaying format 17
default
collating sequence
hexadecimal 248
saving 111
determining order of records for query 105
field selection and sequencing for query 87
record selection for query 91
default values 7
Define Collating Sequence display 115
Define Database File Output display 155
Define Numeric Field Editing display 122
Define Printer Output display 148
Define Report Breaks display 139
Define Result Fields display 57
Define Spooled Output display 151
Define the Query display 28
defining
result field 57
your own collating sequence 115
definition
CCSID (coded character set identifier) 246
code page 114
deleting query
DLTQRY command 11
expression 58
query 176
Index
267