SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-17
I
HIST_SECURITY_WARNINGS
default 10-53
Host variable arrays, INSERT
statement 2-172
Host variables, INSERT statement 2-175
HOUR function
examples of 9-71
syntax diagram of 9-71
I
Identifiers 6-56
ID, authorization 1-5
IF statement
examples of 3-62, 3-63
syntax diagram of 3-61
import utility 5-31
IN predicate
examples of 6-96
limits C-1
logical equivalent using ANY 6-95
operand requirements 6-95
syntax diagram of 6-94
Index keys 6-62
Indexes
ALTER INDEX statement 2-7
CREATE INDEX statement 2-54
description of 6-59
limits C-1
POPULATE INDEX utility 5-112
populating 2-59
INDEXJOIN 2-40
INDEX_ELIMINATION_LEVEL
default 10-65
INFER_CHARSET default 10-46
INFO DEFINE command
examples of 4-45
syntax diagram of 4-45
INFO operation 5-65
INITIALIZE SQL statement
authorization and availability
requirements 2-168
INITIALIZE SQL statement (continued)
examples of 2-168
purpose of 2-168
syntax diagram of 2-168
INSERT access privilege 2-162, 2-190
INSERT function
examples of 9-72
syntax diagram of 9-72
INSERT statement
access options 2-173
compatible data types 2-175
considerations 2-173
DEFAULT values 2-173
lock modes 2-173
MXCI examples of 2-177
ORDER BY clause 2-172
query expression within 2-171
syntax diagram of 2-169
target column list 2-171
using host variables 2-175
VALUES specification within 2-175
INSERT statement (embedded)
C examples of 2-179
COBOL examples of 2-179
Insertable views 2-115
INSERT_VSBB default 10-71
INTEGER data type 6-35
INTERACTIVE_ACCESS default 10-75
INTERVAL data
inserting into SQL/MP columns 6-73
selecting from SQL/MP tables 6-33
Interval data type
description of 6-31
examples of literals 6-75
Interval literals
description of 6-71
examples of 6-75
Interval value expression
examples of 6-49
syntax diagram of 6-47