SQL/MX Comparison Guide for SQL/MP Users

Quick Reference to Differences
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
2-8
EXTEND function No
EXTENT file attribute Yes See SQL/MX Reference Manual
FC command Yes See SQL/MX Reference Manual
FETCH statement Yes See SQL/MX Reference Manual
File attributes Changed See SQL/MP Reference Manual
File organization Changed See SQL/MP Reference Manual
FILEINFO command Changed Replaced SHOWLABEL utility. See
SQL/MX Reference Manual.
FILENAMES command No
FILES command No
FILES table Changed Metadata tables are implemented
differently. See SQL/MX Reference
Manual
Filesets No
Floating point data type for C
and C++
Yes See the SQL/MX Reference Manual
FREE RESOURCES
statement
No
Functions Yes See Section 3, DML Features and
SQL/MX Reference Manual
FUP command No
Generalized owner No
GET CATALOG OF
SYSTEM statement
No
GET VERSION OF
PROGRAM statement
No
GET VERSION statement No
GOAWAY command Changed Replaced by mxtool FIXUP
command
Group manager No
Guardian names Yes See the SQL/MX Reference Manual
HEADING clause Yes See SQL/MX Reference Manual
HEADINGS option Yes See SQL/MX Report Writer Guide
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 8 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments