SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-23
G
Functions (continued)
COUNT C-130
CURRENT C-173
CURRENT_TIMESTAMP C-174
DATEFORMAT D-14
date-time D-10
DAYOFWEEK D-17
description of F-32
EXTEND E-28
JULIANTIMESTAMP J-4
LINE NUMBER L-14
MAX M-1
MIN M-3
PAGE_NUMBER P-3
POSITION P-23
scalar F-33, S-46
SETSCALE S-46
string S-80
SUBSTRING S-84
SUM S-89
TRIM T-11
UPSHIFT U-14
FUP command F-33/F-36
FUP LICENSE command F-35
G
Generalized owner G-1, S-9, S-14
Generic lock L-51
GET CATALOG OF SYSTEM
statement G-1
GET VERSION OF PROGRAM
statement G-4
GET VERSION statement G-2
GOAWAY command G-6, U-17
GRANT statement S-68
Granularity L-49
GROUP BY clause
and null values N-9
and UNION operator S-27
SELECT statement S-22, S-25
Group manager G-7, S-12
Group number S-12
Grouped rows, conditions S-21
Grouped view
description of S-24
FROM clause S-19
view creation C-170
GROUPID
in PROGRAMS table P-31
in TABLES table T-2
Groups
and GROUP BY clause S-22
and SECURE file attribute S-11
and SELECT statement S-27
Guardian names G-7
Guardian processes E-2
Guardian user IDs S-12
H
HASH JOIN option, CONTROL QUERY
directive C-75
Hash joins
restrictions on C-80
with CONTROL QUERY directive C-75
HAVING clause
and UNION operator S-27
SELECT statement S-21
HEADING clause
ALTER VIEW statement A-50
CREATE TABLE statement C-157
CREATE VIEW statement C-167
description of H-1
HEADING in COLUMNS table C-47
Headings
concatenated print items C-64
multiple line N-4
print item D-48
print item default D-50
suppressing in reports H-1
HEADINGS layout option H-2, R-10