FUP Overview
File Utility Program (FUP) Reference Manual—523323-014
1-27
Handling SQL/MX Files
indexes that depend on the table are loaded automatically. No SQL/MP commands
load indexes directly.
ï‚·
For compatibility with the FUP PURGE command, substitute the keyword PURGE
for DROP in the SQL/MP DROP utility.
Handling SQL/MX Files
SQL/MX is a relational database management system that promotes efficient online
access to large distributed databases.
Table 1-3. FUP Commands and SQL/MX Files
Applicable to SQL/MX File Type
FUP Command Table Index
Resource
Fork
Metadata
Tables
MXCI
Equivalent
ALLOCATE No No No No
ALTER No No No No
BUILDKEYRECORDS No No No No
CHECKSUM Yes Yes Yes Yes
COPY No No No No
CREATE No No No No CREATE
TABLE
DEALLOCATE No No No No
DUP No No No No
FILES Yes Yes Yes Yes
FILENAMES Yes Yes Yes Yes
GIVE No No No No
INFO Yes Yes Yes Yes MXCI
SHOWLABEL
LICENSE No No No No
LISTOPENS Yes Yes Yes Yes
LOAD No No No No
LOADALTFILE No No No No
PURGE No No No No MXCI DROP
utility
PURGEDATA No No No No
RELOAD Yes Yes Yes Yes
RENAME No No No No
REVOKE No No No No
SECURE No No No No
SUBVOLS Yes Yes Yes Yes