IBM SC41-5210-04 manual Currentdate ISO JIS Local

constant	(continued)
graphic
migration			241
numeric
record selection test						94
result field			59
control language (CL)					5
creating database files						5
Copy Queries display					177
copying
query definition				173, 177
count summary function
null value		136
cover page
CCSID (coded character set identifier) 253
defining for printout					152
Create and Select Field Definitions display
(IDDU)	200, 202
Create Field Definitions display (IDDU) 201
Create File Definition display (IDDU)							200
creating
access path			232
database file
description			5
example 203
expression
general rules				83
query definition
advanced example						215
considerations					30
example		206
suggested sequence of tasks							31
Work with Queries display 12, 27
result field		57
currency symbol
edited numeric field					126
CURRENT function				80

D

data

entering 203

data description specifications (DDS) introduction 5

data file utility (DFU) 4 data type

date 66 Dec column

E182 J 182 L 182 O 182 T 182 V 182 Z 182

time 66 timestamp 66

database file creating

example 203

database file (continued) output

maximum record length 30 output to

differences between Query/36 and Query for

iSeries			196
overriding			187
database, relational
definition		5
date
arithmetic operation						70
converting numeric to date								71
decrementing					71
incrementing					71
numeric dates, working with								71
comparison			96
constant
record selection test							95
data type			67
description				66, 67
DATE function					75
displaying format 17, 69
EUR	67
format separator					67
function
CURRENT(DATE)							80
ISO	67
JIS	67
LOCAL		67
OS/400 format					67
sort considerations						108
USA	67
value
length		120
date and time format
EUR	67
ISO	67
JIS	67
LOCAL		67
OS/400 format					67
USA	67
date arithmetic operation
addition rules				69
subtraction rules					70
date data
Display Report Layout display								8
date duration			73
date field
collating sequence						112
release restrictions						241
date field name				66
DATE function
argument rules					75
syntax diagram					75
date value
arithmetic			69

length 120

date, time, and timestamp field collating sequence

minimum or maximum values 112

266Query for iSeries Use V5R2