File Utility Programming (FUP) Reference Manual

FUP Overview
File Utility Program (FUP) Reference Manual—523323-015
1-27
Handling SQL/MX Files

Although most FUP commands apply only to the SQL/MP object program files, you
can execute any of the commands directly from the SQL/MP Conversational
Interface (SQLCI).

If you use the FUP DUP command to duplicate an SQL/MP object program file, the
SQL/MP SENSITIVE and SQL/MP VALID flags in the file label of the duplicate
copy are turned off, and a warning message indicates that you must compile the
file again with the SQL/MP compiler.

The only way to SQL/MP license an SQL/MP object program file is to apply the
FUP LICENSE command to the file.

Although you can use the FUP CHECKSUM command to handle SQL/MP tables
and indexes, it does not apply to SQL/MP views (protection and shorthand).
SQL/MP views are skipped, and a warning message appears during a FUP
CHECKSUM process.

To display information about Enscribe and SQL/MP files, use the FUP INFO
command or the SQLCI FILEINFO utility. Although these two methods have the
same function and listing formats, the FUP INFO fileset-list parameter does
not support the FROM CATALOG option or any DEFINE specifications.

The SQL/MP LOAD utility is equivalent to both FUP LOAD and FUP
LOADALTFILE. When you use SQL/MP LOAD to load an SQL/MP table, all
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