SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-14
G
FFDC_DIALOUTS_FOR_MXCMP
default 10-54
File attributes
summary of 8-1
ALTER INDEX use of 8-1
ALTER TABLE use of 8-1
AUDITCOMPRESS 8-3
BLOCKSIZE 8-4
CLEARONPURGE 8-5
CREATE INDEX use of 8-1
CREATE TABLE use of 8-1
description of 8-1
EXTENT 8-6
MAXEXTENTS 8-8
File options
CREATE INDEX use of 2-54
CREATE TABLE use of 2-75
STORE BY 2-82, 7-22
File organizations
entry-sequenced 1-30
key-sequenced 1-30
relative 1-30
restrictions on 1-30
First (partition) keys 6-59
Fixed-length character column 6-21
FIXUP operation 5-11
FLOAT data type 6-35
Floating-point data, description of 6-17
FLOATTYPE default 10-39
FLOOR function
examples of 9-63
syntax diagram of 9-63
Foreign key, ALTER TABLE statement 2-16
Functions, ANSI compliant 1-33
G
GENERATE_EXPLAIN default 10-54
GEN_EIDR_BUFFER_SIZE default 10-54
GEN_MAX_NUM_PART_DISK_ENTRIES
default 10-51
GEN_PA_BUFFER_SIZE default 10-55
GET DESCRIPTOR statement
C examples of 3-54
COBOL examples of 3-55
retrieving item count and values 3-48
syntax diagram of 3-47
GET DIAGNOSTICS statement
C examples of 3-60
COBOL examples of 3-61
getting condition information 3-57
getting statement information 3-57
syntax diagram of 3-56
GOAWAY operation 5-15
GRANT EXECUTE statement
authorization and availability
requirements 2-146
examples of 2-146
security 2-146
syntax diagram of 2-145
GRANT statement
authorization and availability
requirements 2-143
examples of 2-143
security 2-143
syntax diagram of 2-141
Guardian name resolution 10-49
Guardian physical name 6-12
H
Hash groupby, scratch files 10-61
Hash join
performance 2-40
scratch files 10-61
Hash partitioning
description of 6-82
MODIFY utility 5-49
HISTINTS metadata table 10-73
Histogram tables
creating 10-68
dropping 10-68