SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-7
D
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-41
syntax diagram of 9-41
Cursor position
DELETE statement use of 2-113
UPDATE statement use of 2-236
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-9
ALTER TABLE 2-11
ALTER TRIGGER 2-26
CREATE CATALOG 2-52
CREATE INDEX 2-54
CREATE SCHEMA 2-68
CREATE SQLMP ALIAS 2-71
CREATE TABLE 2-75
CREATE TRIGGER 2-96
CREATE VIEW 2-105
DROP CATALOG 2-119
DROP INDEX 2-120
Data Definition Language (DDL)
statements (continued)
DROP PROCEDURE 2-122
DROP SCHEMA 2-124
DROP SQL 2-127
DROP SQLMP ALIAS 2-128
DROP TABLE 2-130
DROP TRIGGER 2-132
DROP VIEW 2-133
GRANT 2-141
GRANT EXECUTE 2-145
INITIALIZE SQL 2-148
REVOKE 2-170
REVOKE EXECUTE 2-173
SET 2-211
SIGNAL SQLSTATE 2-227
Data Manipulation Language (DML)
statements
summary of 2-3
DELETE statement 2-110
INSERT statement 2-149
SELECT statement 2-178
UPDATE statement 2-231
Data type conversion, CAST
expression 9-22
Data types
approximate numeric
descriptions of 6-33
DOUBLE PRECISION 6-35
FLOAT 6-35
REAL 6-35
character 6-16, 6-20
comparable and compatible 6-16
datetime 6-16, 6-24
exact numeric
DECIMAL 6-34
INTEGER 6-34
LARGEINT 6-34
NUMERIC 6-33
PICTURE 6-34