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

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-16
I
HIST_NO_STATS_REFRESH_INTERVAL
default 10-43
HIST_NO_STATS_ROWCOUNT
default 10-43
HIST_NO_STATS_UEC default 10-43
HIST_PREFETCH default 10-43
HIST_ROWCOUNT_REQUIRING_STATS
default 10-44
HIST_SAME_TABLE_PRED_REDUCTION
default 10-44
HIST_SCRATCH_VOL default 10-44
HIST_SECURITY_WARNINGS
default 10-45
Host variable arrays, INSERT
statement 2-148
Host variables, INSERT statement 2-151
HOUR function
examples of 9-65
syntax diagram of 9-65
I
Identifiers 6-52
ID, authorization 1-5
IF statement
examples of 3-61, 3-62
syntax diagram of 3-60
import utility 5-21
IN predicate
examples of 6-92
limits C-1
logical equivalent using ANY 6-91
operand requirements 6-91
syntax diagram of 6-90
Index keys 6-58
Indexes
ALTER INDEX statement 2-7
CREATE INDEX statement 2-52
description of 6-55
limits C-1
POPULATE INDEX utility 5-73
populating 2-57
INDEXJOIN 2-38
INDEX_ELIMINATION_LEVEL
default 10-56
INFO DEFINE command
examples of 4-32
syntax diagram of 4-32
INFO operation 5-40
INITIALIZE SQL statement
authorization and availability
requirements 2-144
examples of 2-144
purpose of 2-144
syntax diagram of 2-144
INSERT access privilege 2-138, 2-166
INSERT function
examples of 9-66
syntax diagram of 9-66
INSERT statement
access options 2-149
compatible data types 2-151
considerations 2-149
DEFAULT values 2-149
limits 2-149, C-1
lock modes 2-149
MXCI examples of 2-153
ORDER BY clause 2-148
query expression within 2-147
syntax diagram of 2-145
target column list 2-147
using host variables 2-151
VALUES specification within 2-151
INSERT statement (embedded)
C examples of 2-155
COBOL examples of 2-155
Insertable views 2-108
INSERT_VSBB default 10-61
INTEGER data type 6-32
INTERACTIVE_ACCESS default 10-65