SQL/MX Comparison Guide for SQL/MP Users
Index
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
Index-2
D
COMMENT statement 2-3
Comments 2-3
COMMENTS table 2-3
COMMIT option 2-3
COMMIT WORK statement 3-19
Comparison predicate 2-3
Compile
SQL/MP 4-10
SQL/MX 4-11
COMPUTE_TIMESTAMP function 2-3
CONCAT clause 2-3
Constraints 2-4, 6-4
CONSTRNT table 2-4
CONTINUE statement 2-4
CONTROL EXECUTOR directive 2-4
CONTROL QUERY directive 3-23
CONTROL TABLE directive 3-21
Conversion, data types 4-3
CONVERT command 2-4
CONVERTTIMESTAMP function 2-4
COPY command 2-4
Correlation names 2-4
COUNT function 2-4
CPRLSRCE table 2-4
CPRULES table 2-4
CREATE CATALOG statement 2-4
CREATE COLLATION statement 2-4
CREATE CONSTRAINT statement 2-5
CREATE INDEX statement 2-5
CREATE SYSTEM CATALOG
statement 2-5
CREATE TABLE statement 2-5
CREATE VIEW statement 2-5
CURRENT function 2-5
CURRENT_TIMESTAMP function 2-5
Cursors
summary 2-5
updatable 4-6
D
Data Definition Language statements 6-1
Data dictionary 2-5
Data types
conversion 4-3
date-time 3-1
description of 3-1
differences 3-1
interval 3-2
VARCHAR 4-2
Database object names 6-1
Data-flow task model 5-5
DATE data type 2-5
DATEFORMAT function 2-5
DATETIME data type 2-5
Datetime data types 3-1
Datetime literals 3-6
Datetime value functions 3-9
Date-time data types 2-5
Date-time functions 2-5
Date-time literals 2-5
DATE_FORMAT option 2-5
DAYOFWEEK function 2-5
DCL (Data Control Language)
statements 2-6
DCOMPRESS 2-6
DEALLOCATE file attribute 2-6
DECIMAL_POINT option 2-6
DECLARE CURSOR statement 2-6
DEFAULT clause 2-6
Default settings
SQL/MP 3-23
SQL/MX 5-7
DEFINEs 1-2
DELETE DEFINE statement 2-6
DELETE statement 2-6
Delimited identifiers 3-5
DESCRIBE INPUT statement 2-6
DESCRIBE statement 2-6
Descriptor area 4-7