FUP Overview
File Utility Program (FUP) Reference Manual—523323-014
1-25
Handling SQL/MP Files
Table 1-2 shows the FUP commands that do not apply to all the different types of
SQL/MP files and lists any alternative methods for manipulating the files.
Table 1-2. FUP Commands and SQL/MP Files (page1of2)
Applicable to SQL/MP File Type
FUP Command Table View Index Partition Catalog
SQLCI
Equivalent
ALLOCATE No No No No No CREATE
TABLE
CREATE
INDEX
ALTER TABLE
ALTER INDEX
ALTER No No No No No ALTER TABLE
ALTER INDEX
BUILDKEYRECORDS No No No No No CREATE
TABLE
CHECKSUM Yes No Yes Yes No
COPY No No No No No COPY utility
CREATE NoNoNoNo No CREATE
TABLE
CREATE
INDEX
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
1 = Yes for protection views; No for shorthand views