IBM ISERIES SC41-5210-04, User Manual

Page: 283 / 294

function (continued)
HOUR
argument rules 76
syntax diagram 76
introduction 5
MICROSECOND
argument rules 77
syntax diagram 77
minimum summary
null value 135
MINUTE
argument rules 77
syntax diagram 77
MONTH
argument rules 78
syntax diagram 78
SECOND
argument rules 78
syntax diagram 78
SUBSTR (substring) 61
substring
argument rules 60
summary
average 135
CCSID (coded character set identifier) 253
count 135
location on report 137
maximum 135
minimum 135
performance recommendations 237
report 237
summarizing columns 137
total 135
types 135
TIME
argument rules 79
syntax diagram 79
TIMESTAMP
argument rules 79
syntax diagram 79
total summary
date, time, and timestamp value 135
null value 135
VALUE 62
VARCHAR 63
VARGRAPHIC 65
YEAR
argument rules 80
syntax diagram 80
function key
F10
showing previous display 18
F11
displaying additional information 15
F12
canceling changes made 18
F13
using to display report layout 8
F17
display date and time format 18, 69
function key (continued)
F21
to select all 30
F23
set collating sequence default 111, 116
using to display a long comment 10
F4
using to obtain a list 9
F5
displaying report 169
using to display report 8
introduction to using 8
G
GE (greater than or equal) comparison test 95, 96,
165
generic name 9
GG (double-byte G) 9
GT (greater than) comparison test 95, 96, 165
H
heading
column in report 119
report 153
result field 85
hexadecimal
CCSID 114
collating sequence 113, 114
HOUR function
argument rules 76
syntax diagram 76
how a collating sequence affects Query for iSeries 112
how to join files 43
I
IBM European standard (EUR)
date and time 67
IBM USA standard (USA)
date and time 67
ID (identifier)
differences between Query/36 and Query for
iSeries 195
file 36
Using in a query definition 36
IDDU (interactive data definition utility)
data dictionary 4
definition 199
example
creating IDDU definition 199
introduction 4
main (system) menu 199
identifier (ID)
differences between Query/36 and Query for
iSeries 195
file 36
Using in a query definition 36
Ignore Character Substitution display 165
ignoring decimal data error 164
Index
271