SQL/MX Comparison Guide for SQL/MP Users

HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
Index-1
Index
A
Access options
differences 3-16
STABLE access 3-17
summary 2-1
Access plans
forcing 5-8
influencing 5-7
reviewing with EXPLAIN function 5-8
ADD DEFINE 2-1
Aggregate functions 2-1, 3-11
Aliases 2-1
ALLOCATE file attribute 2-1
ALTER CATALOG statement 2-1
ALTER COLLATION statement 2-1
ALTER DEFINE statement 2-1
ALTER INDEX statement 2-1
ALTER PROGRAM statement 2-1
ALTER TABLE statement 2-1
ALTER VIEW statement 2-1
ANSI compatibility 1-5
APPEND command 2-1
APPENDCANCEL command 2-1
APPENDRESTART command 2-2
AS clause 2-2
AS DATE/TIME clause 2-2
ASCII character set 2-2
AUDIT file attribute 2-2
AUDITCOMPRESS file attribute 2-2
Audited tables 2-2
AUTOCOMMIT
example of 3-20
for transactions 3-19
AVG function 2-2
B
BACKUP utility 2-2
BASETABS table 2-2
BEGIN DECLARE SECTION statement 2-2
BEGIN WORK statement 2-2, 3-18
BETWEEN predicate 2-2
BLOCKSIZE file attribute 2-2
BREAK FOOTING command 2-2
BREAK ON command 2-2
BREAK TITLE command 2-2
BUFFERED file attribute 2-2
C
c89 2-5
Cache 3-24/3-26
CANCEL command 2-2
CASE expression 2-2
CAST function
and descriptor area 4-8
data conversion 4-3
CATALOG command 2-2
Catalogs 6-2
CATALOGS table 2-3
CENTER_REPORT option 2-3
Character data type 2-3
Character expression 2-3
Character sets 2-3
CHAR_LENGTH function 2-3
CLEANUP command 2-3
CLEARONPURGE file attribute 2-3
CLOSE statement 2-3
Clustering keys 2-3
COLLATE clause 2-3
Collation definitions 2-3
Collations 2-3
Column Identifier 2-3
Columns 2-3
COLUMNS table 2-3