IBM ISERIES SC41-5210-04 - Manual (Page 278)

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
E 182
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
266 Query for iSeries Use V5R2