IBM SC41-5210-04 manual Function

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