symbolic character
DBCS (double-byte character set)
4
system administrator guidelines
243
system sort sequence
117
T
test
displaying
53
test pattern
DBCS LIKE
99
DBCS-graphic field
empty string
100
declaring
98
empty string
98
non-DBCS
special characters
99
special characters
98
test, join
CCSID (coded character set identifier)
252
code
displaying
43
L, T, or Z
43
specifying
43
text, break
144
thousands separator
numeric fields
125
time
arithmetic operation
decrementing
73
incrementing
73
subtraction
73
comparison
96
constant
record selection test
95
data type
description
66, 67
displaying format
17, 69
EUR
67
function
CURRENT(TIME)
80
CURRENT(TIMEZONE)
80
ISO
67
JIS
67
LOCAL
67
OS/400 format
67
sort considerations
108
USA
67
value
length
120
time arithmetic operation
addition rules
69
subtraction rules
70
time data
Display Report Layout display
8
time duration
73
time field
collating sequence
112
release restrictions
241
time field editing
127
time field name
66
TIME function
argument rules
79
syntax diagram
79
time value
arithmetic
69
timestamp
arithmetic operation
addition rules
73
decrementing
73
incrementing
73
subtraction
70, 73
comparison
96
constant
record selection test
95
data type
description
66, 68
function
CURRENT(TIMESTAMP)
80
sort considerations
108
value
length
120
timestamp data
Display Report Layout display
8
timestamp duration
74
timestamp field
collating sequence
112
release restrictions
241
timestamp field name
66
TIMESTAMP function
argument rules
79
syntax diagram
79
timestamp value
arithmetic
69
tips and techniques
using Query
231
total summary function
date, time, and timestamp value
135
null values
135
translation table
CCSID (coded character set identifier)
116
selecting for collating sequence
116
U
UCS2 level 1 support
4
unmatched records with primary file join
field length restrictions
44
records in primary file without matching records
43
USA (IBM USA standard)
date and time
67
user-defined collating sequence
115
using collating sequence
165
V
value
comparison
93
default
93
null
record selection test
95
VALUE function
62
278
Query for iSeries Use V5R2