SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-7
D
CREATE VIEW statement (continued)
syntax diagram of 2-104
updatability requirements 2-107
WITH CHECK OPTION within 2-107
CROSS join, description of 2-183
CROSS_PRODUCT_CONTROL
default 10-54
Ctrl-c, effect on queries 1-5
Ctrl-Y, effect on MXCI session 4-28
CURRENT_DATE function
examples of 9-35
syntax diagram of 9-35
CURRENT_TIME function
examples of 9-36
precision specification within 9-36
syntax diagram of 9-36
CURRENT_TIMESTAMP function
examples of 9-34, 9-37
precision specification within 9-34, 9-37
syntax diagram of 9-34, 9-37
CURRENT_USER function
examples of 9-37
syntax diagram of 9-37
Cursor position
DELETE statement use of 2-112
UPDATE statement use of 2-231
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-24
CREATE CATALOG 2-50
CREATE INDEX 2-52
Data Definition Language (DDL)
statements (continued)
CREATE SCHEMA 2-66
CREATE SQLMP ALIAS 2-70
CREATE TABLE 2-74
CREATE TRIGGER 2-95
CREATE VIEW 2-104
DROP CATALOG 2-118
DROP INDEX 2-119
DROP PROCEDURE 2-120
DROP SCHEMA 2-121
DROP SQL 2-124
DROP SQLMP ALIAS 2-125
DROP TABLE 2-127
DROP TRIGGER 2-129
DROP VIEW 2-130
GRANT 2-138
GRANT EXECUTE 2-141
INITIALIZE SQL 2-144
REVOKE 2-166
REVOKE EXECUTE 2-169
SET 2-207
SIGNAL SQLSTATE 2-222
Data Manipulation Language (DML)
statements
summary of 2-3
DELETE statement 2-109
INSERT statement 2-145
SELECT statement 2-174
UPDATE statement 2-226
Data type conversion, CAST
expression 9-20
Data types
and SPJ methods 2-61
approximate numeric
descriptions of 6-31
DOUBLE PRECISION 6-33
FLOAT 6-33
REAL 6-33
character 6-19