File Utility Programming (FUP) Reference Manual

FUP Overview
File Utility Program (FUP) Reference Manual—523323-015
1-25
Handling OSS Files
5. The file contains no more than 15 secondary partitions.
Handling OSS Files
FUP can only handle OSS files with the FUP INFO command. OSS files cannot be
specified in any other FUP commands.
Handling SQL/MP Files
One of the relational database management systems that is used to define and
manipulate industry-standard Structured Query Language (SQL) is SQL/MP. SQL/MP
files include object programs, tables, views, indexes, partitions, and catalogs. All the
FUP commands (unless noted) are applicable to the SQL/MP object program 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.
Note. The primary partition can also be created with different extent sizes than the other
partitions.
Note. The FUP SET, RESET, and SHOW commands do not apply to SQL/MP files. They
apply only to Enscribe files. The FUP control commands described in Appendix B, FUP
Command Summary, do not operate on SQL/MP 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
1 = Yes for protection views; No for shorthand views