NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-24
H
GROUPID
in PROGRAMS table P-30
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-70
Hash joins
restrictions on C-75
with CONTROL QUERY
directive C-70
HAVING clause
and UNION operator S-27
SELECT statement S-21
HEADING clause H-1
ALTER VIEW statement A-45
CREATE TABLE statement C-146
CREATE VIEW statement C-157
Heading for column, changing A-31
HEADING in COLUMNS table C-42
Headings
concatenated print items C-59
multiple line N-4
print item D-45
print item default D-47
suppressing in reports H-1
HEADINGS layout option H-1, R-11
HEADINGTEXT in COLUMNS table C-42
HELP command H-2
HELP TEXT statement H-3
Help text, deleting H-4
Hidden text C-46
HISTORY buffer H-4
HISTORY command H-4
Host and SQL communication H-5
Host identifiers H-5
Host language
compiler versions V-8
defined E-1
description of H-5
Host object SQL version (HOSV) V-7, V-8
Host programming language, defined E-1
Host programs H-5
Host variables
declaration B-2
description of H-5
substituting values in a query H-6
TYPE AS clause H-6
HOSV (host object SQL version) V-7, V-8
I
ICOMPRESS file attribute
description of I-1
displaying F-18
ICOMPRESS, in FILES table F-28
Identifiers, SQL S-60
IDs S-12
IF/THEN/ELSE clause
description of I-1
report writer option R-12
IN predicate I-3, L-8
INCLUDE SQLCA directive I-4
INCLUDE SQLDA directive
collation buffer I-6
description of I-5
names buffer I-5
INCLUDE SQLSA directive I-6
INCLUDE STRUCTURES directive I-7
Index
address of EOF F-20
ALTER INDEX statement A-12