SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-7
D
CREATE VIEW statement (continued)
syntax diagram of 2-110
updatability requirements 2-114
WITH CHECK OPTION within 2-113
CROSS join, description of 2-206
CROSS_PRODUCT_CONTROL
default 10-58
Ctrl-c, effect on queries 1-5
Ctrl-Y, effect on MXCI session 4-28
CURRENT_DATE function
examples of 9-38
syntax diagram of 9-38
CURRENT_TIME function
examples of 9-39
precision specification within 9-39
syntax diagram of 9-39
CURRENT_TIMESTAMP function
examples of 9-37, 9-40
precision specification within 9-37, 9-40
syntax diagram of 9-37, 9-40
CURRENT_USER function
examples of 9-40
syntax diagram of 9-40
Cursor position
DELETE statement use of 2-118
UPDATE statement use of 2-255
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-7
ALTER SQLMP ALIAS 2-8
ALTER TABLE 2-10
ALTER TRIGGER 2-26
CREATE CATALOG 2-54
CREATE INDEX 2-56
Data Definition Language (DDL)
statements (continued)
CREATE SCHEMA 2-71
CREATE SQLMP ALIAS 2-75
CREATE TABLE 2-79
CREATE TRIGGER 2-101
CREATE VIEW 2-110
DROP CATALOG 2-124
DROP INDEX 2-125
DROP PROCEDURE 2-126
DROP SCHEMA 2-127
DROP SQL 2-130
DROP SQLMP ALIAS 2-131
DROP TABLE 2-133
DROP TRIGGER 2-135
DROP VIEW 2-136
GRANT 2-161
GRANT EXECUTE 2-164
INITIALIZE SQL 2-167
REVOKE 2-189
REVOKE EXECUTE 2-192
SET 2-230
SIGNAL SQLSTATE 2-246
Data Manipulation Language (DML)
statements
summary of 2-3
DELETE statement 2-115
INSERT statement 2-168
SELECT statement 2-197
UPDATE statement 2-250
Data type conversion, CAST
expression 9-20
Data types
and SPJ methods 2-65
approximate numeric
descriptions of 6-32
DOUBLE PRECISION 6-34
FLOAT 6-34
REAL 6-34
character 6-20