SQL/MX Comparison Guide for SQL/MP Users

Index
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
Index-3
E
DETAIL command 2-6
Diagnostics area 4-9
Differences, NonStop SQL/MP and
NonStop SQL/MX 1-2
DISPLAY STATISTICS command 2-6
DISPLAY USE OF command 7-1
DISTINCT clause 2-6
DML features 3-1
DML statements 3-12
DOWNGRADE CATALOG command 2-6
DOWNGRADE SYSTEM CATALOG
command 2-7
DROP statement 2-7
DROP SYSTEM CATALOG statement 2-7
DSL (Data Status Language)
statements 2-7
DSLACK file attribute 2-7
DUP command 2-7
Dynamic SQL 4-6
E
EDIT command 2-7
Embedded SQL 4-1
END DECLARE SECTION statement 2-7
ENV command 2-7
ERROR command 2-7
Error handling 4-5, 4-8, 4-9
EXECUTE IMMEDIATE statement 2-7
EXECUTE statement 2-7
Executor
design differences 5-3
query plan 5-5
queues 5-5
SQL/MP iterator model 5-4
SQL/MX task model 5-5
EXISTS predicate 2-7
EXIT command 2-7
EXPLAIN directive 2-7
EXPLAIN function, reviewing access
plans 5-8
Explicit transactions 3-18
Expressions 2-7
Expressions, interval value 3-10
EXTEND function 2-8
EXTENT file attribute 2-8
F
FC command 2-8
FETCH statement 4-6
File attributes 2-8
File organization 2-8
File types 3-4
FILEINFO command 2-8
FILENAMES command 2-8
FILES command 2-8
FILES table 2-8
Filesets 2-8
FIXUP command 7-1
Floating point data type 2-8
FREE RESOURCES statement 2-8
Functions
aggregate 3-11
date-time value 3-9
mathematical 3-10
numeric value 3-9
sequence 3-10
SETSCALE 4-1
FUP command 2-8
G
Generalized owner 2-8
GET CATALOG OF SYSTEM
statement 2-8
GET DESCRIPTOR statement 1-2
GET DIAGNOSTICS statement
C example 4-10
description of 4-9
GET VERSION OF PROGRAM
statement 2-8
GET VERSION statement 2-8
GOAWAY command 7-2