SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-15
G
File options
CREATE INDEX use of 2-56
CREATE TABLE use of 2-79
STORE BY 2-87, 7-22
File organizations
entry-sequenced 1-31
key-sequenced 1-31
relative 1-31
restrictions on 1-31
First (partition) keys 6-58
Fixed-length character column 6-22
FIXUP operation 5-17
FLOAT data type 6-34
Floating-point data, description of 6-18
FLOATTYPE default 10-42
FLOOR function
examples of 9-64
syntax diagram of 9-64
Foreign key, ALTER TABLE statement 2-15
Functions, ANSI compliant 1-34
G
GENERATE_EXPLAIN default 10-59
GEN_EIDR_BUFFER_SIZE default 10-59
GEN_MAX_NUM_PART_DISK_ENTRIES
default 10-54
GEN_MAX_NUM_PART_NODE_ENTRIES
default 10-55
GEN_PA_BUFFER_SIZE default 10-59
GET DESCRIPTOR statement
C examples of 3-53
COBOL examples of 3-54
retrieving item count and values 3-47
syntax diagram of 3-46
GET DIAGNOSTICS statement
C examples of 3-59
COBOL examples of 3-60
getting condition information 3-56
getting statement information 3-56
syntax diagram of 3-55
GOAWAY operation 5-22
GRANT EXECUTE statement
authorization and availability
requirements 2-165
examples of 2-165
security 2-165
syntax diagram of 2-164
GRANT statement
authorization and availability
requirements 2-163
examples of 2-163
security 2-163
syntax diagram of 2-161
GTACL command
examples of 4-31
syntax of 4-31
Guardian name resolution 10-53
Guardian physical name 6-13
H
Hash groupby, scratch files 10-68
Hash join
performance 2-42
scratch files 10-68
Hash partitioning
description of 6-80
MODIFY utility 5-76
HashPartFunc function
examples of 9-65
syntax diagram of 9-65
HISTINTS metadata table 10-80
Histogram tables
creating 10-75
dropping 10-75
examples of 10-81
HISTINTS 10-80
HISTOGRM 10-79
maintaining 10-76
purpose of 10-75
UPDATE STATISTICS use of 2-264