Filter
Top Products
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