SQL/MX Comparison Guide for SQL/MP Users

Index
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
Index-5
M
M
Mathematical functions 3-10
MAX function 2-11
MAXEXTENTS file attribute 2-11
Message file 2-11
Metadata 6-3
MIN function 2-11
MODIFY CATALOG command 2-11
MODIFY LABEL command 2-11
MODIFY REGISTER command 2-11
Multibyte character sets 2-11
MXTOOL utility 7-1
N
NAME command 2-11
NAME option 2-11
Name resolution 1-3
Names 2-11, 6-1
Namespace 6-1
NEWLINE_CHAR option 2-11
NO INVALIDATE option, indexes 6-5
Nonaudited tables 2-11
NonStop SQL/MP 1-1
NonStop SQL/MX 1-1
description of 1-1
parallel operations 1-4
questions about differences 1-2
redesigned optimizer and executor 1-4
NOPURGEUNTIL file attribute 2-11
NULL predicate 2-11
Null value 2-11
NULL_DISPLAY 2-11
Numeric data types 2-11
Numeric literals 2-11
Numeric value expression and
functions 3-9
O
OBEY command 2-11
Object names 6-1
Object namespaces 6-1
OCTET_LENGTH function 2-11
OPEN statement 2-11
Open System Services (OSS) 1-3
Optimizer, design differences 5-1
OSS names 2-11
OUT command 2-11
OUT_REPORT command 2-12
OVERFLOW_CHAR command 2-12
OWNER file attribute 2-12
P
PAGE TITLE option 2-12
PAGE_COUNT option 2-12
PAGE_FOOTING option 2-12
PAGE_LENGTH option 2-12
PAGE_NUMBER option 2-12
PARALLEL EXECUTION, index
loading 6-5
Parallel index loading 2-12
Parameters 2-12
PARTITION clause 2-12
Partition management 2-12
Partitions 6-5
PARTNS table 2-12
Performance 1-4
PERUSE command 2-12
Plans 2-12
Populating indexes 7-2
POSITION function 2-12
Positioned UPDATE Statement 4-6
Predicates
LIKE 3-11
row-value constructors 3-11
PREPARE statement 2-12
Primary keys 2-12
Print item 2-12
PROGID file attribute 2-12
Program compilation
SQL/MP 4-10
SQL/MX 4-11