SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-7
D
CREATE VIEW statement (continued)
examples of 2-115
LOCATION file option within 2-113
syntax diagram of 2-111
updatability requirements 2-115
WITH CHECK OPTION within 2-114
CROSS join, description of 2-207
CROSS_PRODUCT_CONTROL
default 10-64
Ctrl-c, effect on queries 1-5
Ctrl-Y, effect on MXCI session 4-29
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-119
UPDATE statement use of 2-258
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-25
Data Definition Language (DDL)
statements (continued)
CREATE CATALOG 2-52
CREATE INDEX 2-54
CREATE SCHEMA 2-69
CREATE SQLMP ALIAS 2-73
CREATE TABLE 2-77
CREATE TRIGGER 2-101
CREATE VIEW 2-111
DROP CATALOG 2-125
DROP INDEX 2-126
DROP PROCEDURE 2-127
DROP SCHEMA 2-128
DROP SQL 2-131
DROP SQLMP ALIAS 2-132
DROP TABLE 2-134
DROP TRIGGER 2-136
DROP VIEW 2-137
GRANT 2-162
GRANT EXECUTE 2-165
INITIALIZE SQL 2-168
REVOKE 2-190
REVOKE EXECUTE 2-193
SET 2-233
SIGNAL SQLSTATE 2-249
Data Manipulation Language (DML)
statements
summary of 2-3
DELETE statement 2-116
INSERT statement 2-169
SELECT statement 2-198
UPDATE statement 2-253
Data type conversion, CAST
expression 9-20
Data types
and SPJ methods 2-63
approximate numeric
descriptions of 6-35
DOUBLE PRECISION 6-37
FLOAT 6-36