File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-111
INFO DETAIL Listing Format Examples

new-option displays the location of the resource fork for an ANSI table, index, or
metadata table.

The file format is always 2.

The security vector is ‘*SQL.’
The DETAIL listing format for SQL/MX objects also contains:

The ANSI name associated with the object.

The location of system metadata tables associated with the object.

Clustering key information for the objects.

Partitioning information for objects that can be partitioned.

Indexes associated with tables.
INFO DETAIL Listing Format Examples
The listing examples in this section are for Enscribe files.

To show the FUP INFO, DETAIL listing for TEMPE (a DP2 entry-sequenced file):
-INFO TEMPE, DETAIL
$VOL1.SVOL.TEMPE 15 Apr 2001, 21:03
ENSCRIBE
TYPE E
FORMAT 1
EXT (1 PAGES, 1 PAGES)
REC 80
BLOCK 4096
MAXEXTENTS 16
OWNER 1,40
SECURITY (RWEP): CUCU
DATA MODIF: 14 Apr 2001, 16:59
CREATION DATE: 10 Apr 1997, 16:00
LAST OPEN: 14 Apr 2001, 18:00
EOF 0 (0.0% USED)
FILE LABEL: 214 (5.2 % USED)
EXTENTS ALLOCATED: 0

To show the FUP INFO, DETAIL listing for PARTFILE (a key-sequenced,
partitioned file with alternate keys):
-INFO PARTFILE, DETAIL
$VOL1.SVOL.PARTFILE 11 Nov 2000, 14:16
ENSCRIBE
TYPE K
FORMAT 1
EXT ( 1 PAGES, 1 PAGES )
REC 80
Note. For examples of listings for SQL files, see the SQL/MP Reference Manual.