File Utility Programming (FUP) Reference Manual

FUP Overview
File Utility Program (FUP) Reference Manual—523323-015
1-26
Handling SQL/MP Files
SQL/MP File Guidelines

If you use a FUP command that supports only SQL/MP object program files and it
encounters an SQL/MP table or view, the SQL/MP table or view is ignored, and a
warning message appears.

Although you can use FUP commands to provide information about SQL/MP files,
the commands cannot manipulate or duplicate the SQL/MP files.

To display information for the SQL/MP files and SQL/MP object program files, use
the FUP FILES, FILENAMES, INFO, LISTOPENS, and SUBVOLS commands.
DEALLOCATE No No No No No ALTER TABLE
ALTER INDEX
DUP No No No No No DUP utility
FILES Yes Yes Yes Yes Yes
FILENAMES Yes Yes Yes Yes Yes
GIVE No No No No No ALTER
command
SECURE utility
INFO Yes Yes Yes Yes Yes FILEINFO
utility
LICENSE NoNoNoNo No
LISTOPENS Yes 1 Yes Yes Yes
LOAD No No No No No LOAD utility
LOADALTFILE No No No No No LOAD utility
PURGE NoNoNoNo No DROP
command
PURGE utility
PURGEDATA NoNoNoNo No
RELOAD Yes No Yes Yes Yes
RENAME No No No No No
REVOKE No No No No No
SECURE NoNoNoNo No ALTER
command
SECURE utility
SUBVOLS Yes Yes Yes Yes Yes
Table 1-2. FUP Commands and SQL/MP Files (page2of2)
Applicable to SQL/MP File Type
FUP Command Table View Index Partition Catalog
SQLCI
Equivalent
1 = Yes for protection views; No for shorthand views