SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)
Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-7
D
BLOCKSIZE within 9-4
CLEARONPURGE within 9-5
DEFAULT clause 7-2
examples of 2-137
LIKE specification 2-124
MAXEXTENTS within 9-7
reducing space 2-126
syntax diagram of 2-107
CREATE TRIGGER statement
authorization and availability
requirements 2-147
syntax diagram of 2-144
CREATE VIEW statement
authorization and availability
requirements 2-158
examples of 2-160
LOCATION file option within 2-157
syntax diagram of 2-154
updatability requirements 2-160
WITH CHECK OPTION within 2-158
CROSS join, description of 2-339
CROSS_PRODUCT_CONTROL
default 10-67
Ctrl-c, effect on queries 1-5
Ctrl-Y, effect on MXCI session 4-29
CURRENT_DATE function
examples of 8-41
syntax diagram of 8-41
CURRENT_TIME function
examples of 8-42
precision specification within 8-42
syntax diagram of 8-42
CURRENT_TIMESTAMP function
examples of 8-40
, 8-43
precision specification within 8-40, 8-43
syntax diagram of 8-40, 8-43
CURRENT_USER function
examples of 8-43
syntax diagram of 8-43
Cursor position
DELETE statement use of 2-166
UPDATE statement use of 2-390
Cursors
allocating extended 3-3
specifying read-only 3-23
specifying updatable 3-23
D
Data Definition Language (DDL) statements
summary of 2-1
ALTER INDEX 2-11
ALTER SQLMP ALIAS 2-13
ALTER TABLE 2-19
ALTER TRIGGER 2-48
CREATE CATALOG 2-78
CREATE INDEX 2-80
CREATE SCHEMA 2-96
CREATE SQLMP ALIAS 2-104
CREATE TABLE 2-107
CREATE TRIGGER 2-144
CREATE VIEW 2-154
DROP CATALOG 2-180
DROP INDEX 2-181
DROP PROCEDURE 2-182
DROP SCHEMA 2-183
DROP SQL 2-187
DROP SQLMP ALIAS 2-188
DROP TABLE 2-190
DROP TRIGGER 2-192
DROP VIEW 2-193
GRANT 2-240
GRANT EXECUTE 2-246
INITIALIZE SQL 2-251
REVOKE 2-317
REVOKE EXECUTE 2-323
SET 2-365
SIGNAL SQLSTATE 2-381
Data Manipulation Language (DML)
statements










