SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-7
D
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-145
examples of 2-146
LOCATION file option within 2-144
syntax diagram of 2-142
updatability requirements 2-146
WITH CHECK OPTION within 2-145
CROSS join, description of 2-251
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 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-150
UPDATE statement use of 2-302
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-69
CREATE INDEX 2-71
CREATE SCHEMA 2-87
CREATE SQLMP ALIAS 2-91
CREATE TABLE 2-95
CREATE TRIGGER 2-132
CREATE VIEW 2-142
DROP CATALOG 2-156
DROP INDEX 2-157
DROP PROCEDURE 2-158
DROP SCHEMA 2-159
DROP SQL 2-162
DROP SQLMP ALIAS 2-163
DROP TABLE 2-165
DROP TRIGGER 2-167
DROP VIEW 2-168
GRANT 2-197
GRANT EXECUTE 2-203
INITIALIZE SQL 2-208
REVOKE 2-231
REVOKE EXECUTE 2-236
SET 2-277
SIGNAL SQLSTATE 2-293