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