SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-15
G
FLOATTYPE default 10-41
FLOOR function
examples of 9-60
syntax diagram of 9-60
Foreign key, ALTER TABLE statement 2-15
Functions, ANSI compliant 1-34
G
GENERATE_EXPLAIN default 10-55
GEN_EIDR_BUFFER_SIZE default 10-55
GEN_MAX_NUM_PART_DISK_ENTRIES
default 10-52
GEN_MAX_NUM_PART_NODE_ENTRIES
default 10-52
GEN_PA_BUFFER_SIZE default 10-56
GET DESCRIPTOR statement
C examples of 3-52
COBOL examples of 3-53
retrieving item count and values 3-46
syntax diagram of 3-45
GET DIAGNOSTICS statement
C examples of 3-58
COBOL examples of 3-59
getting condition information 3-55
getting statement information 3-55
syntax diagram of 3-54
GOAWAY operation 5-16
GRANT EXECUTE statement
authorization and availability
requirements 2-142
examples of 2-142
security 2-142
syntax diagram of 2-141
GRANT statement
authorization and availability
requirements 2-140
examples of 2-140
security 2-140
syntax diagram of 2-138
Guardian name resolution 10-50
Guardian physical name 6-12
H
Hash groupby, scratch files 10-63
Hash join
performance 2-38
scratch files 10-63
Hash partitioning
description of 6-79
MODIFY utility 5-53
HashPartFunc function
examples of 9-61
syntax diagram of 9-61
HISTINTS metadata table 10-75
Histogram tables
creating 10-70
dropping 10-70
examples of 10-76
HISTINTS 10-75
HISTOGRM 10-74
maintaining 10-71
purpose of 10-70
UPDATE STATISTICS use of 2-240
Histograms
clearing 2-240, 2-246
controls 10-41
generating 2-239
HISTOGRAMS metadata table 10-72
HISTOGRAM_INTERVALS metadata
table 10-73
HISTOGRM metadata table 10-74
HISTORY command
examples of 4-31
syntax diagram of 4-31
HIST_DEFAULT_SEL_FOR_LIKE_WILDC
ARD default 10-42
HIST_DEFAULT_SEL_FOR_PRED_RANG
E default 10-42
HIST_JOIN_CARD_LOWBOUND
default 10-42