IBM SC41-5210-04 manual Currenttime Currenttimezone ISO JIS Local

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

278Query for iSeries Use V5R2