SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)
Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-7
D
AUDITCOMPRESS within 8-3
authorization and availability
requirements 2-112, 2-124
BLOCKSIZE within 8-4
CLEARONPURGE within 8-5
DEFAULT clause 7-2
examples of 2-125
LIKE specification 2-112
MAXEXTENTS within 8-7
reducing space 2-114
syntax diagram of 2-95
CREATE TRIGGER statement
authorization and availability
requirements 2-135
syntax diagram of 2-132
CREATE VIEW statement
authorization and availability
requirements 2-146
examples of 2-148
LOCATION file option within 2-145
syntax diagram of 2-142
updatability requirements 2-148
WITH CHECK OPTION within 2-146
CROSS join, description of 2-264
CROSS_PRODUCT_CONTROL
default 10-69
Ctrl-c, effect on queries 1-6
Ctrl-Y, effect on MXCI session 4-29
CURRENT_DATE function
examples of 9-41
syntax diagram of 9-41
CURRENT_TIME function
examples of 9-42
precision specification within 9-42
syntax diagram of 9-42
CURRENT_TIMESTAMP function
examples of 9-40, 9-43
precision specification within 9-40, 9-43
syntax diagram of 9-40, 9-43
CURRENT_USER function
examples of 9-43
syntax diagram of 9-43
Cursor position
DELETE statement use of 2-154
UPDATE statement use of 2-315
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-8
ALTER SQLMP ALIAS 2-10
ALTER TABLE 2-12
ALTER TRIGGER 2-40
CREATE CATALOG 2-70
CREATE INDEX 2-72
CREATE SCHEMA 2-88
CREATE SQLMP ALIAS 2-92
CREATE TABLE 2-95
CREATE TRIGGER 2-132
CREATE VIEW 2-142
DROP CATALOG 2-163
DROP INDEX 2-164
DROP PROCEDURE 2-165
DROP SCHEMA 2-166
DROP SQL 2-169
DROP SQLMP ALIAS 2-170
DROP TABLE 2-172
DROP TRIGGER 2-174
DROP VIEW 2-175
GRANT 2-205
GRANT EXECUTE 2-211
INITIALIZE SQL 2-216
REVOKE 2-243
REVOKE EXECUTE 2-248
SET 2-290










