LISTF, LISTFL, LISTFR

The LISTF command lists all files defined in the VOC. The LISTFL and LISTFR commands show only local or remote files.

Format

LISTF {modes} {LPTR}

LISTFL {modes} {LPTR}

LISTFR {modes} {LPTR}

The LISTF command is a sentence to list all F type VOC entries. The listing shows the VOC name of the file, the file type, the description (field 1 of the VOC entry), the data portion pathname (field 2) and the dictionary pathname (field 3). The report is sorted by file name.

The LISTFL command is similar but shows only files that are local to the account. Selection is performed by reporting only those records for which the data portion pathname does not contain a directory separator character. It is thus possible to defeat this selection process by using absolute pathnames for local files. The CREATE.FILE command always uses the file name only for a local file.

The LISTFR command is similar but shows only files that are remote to the account. Selection is performed by reporting only those records for which the data portion pathname contains a directory separator character.

The file type column shows:

DH	for a dynamic hash file. This type code may be followed by

C	the file is a data collection

D	the file uses data integrity constraints

E	the file uses encryption

I	the file has alternate key indices

R	the file is exported for replication

S	file statistics are enabled

T	the file has a trigger function defined

X	the file is in ECS mode

Dir	for a directory file. This type code may be followed by

E	the file uses encryption

L	the file uses forced lowercase ids

R	the file is exported for replication

T	the file has a trigger function defined

U	the file uses forced uppercase ids

Mult	for a multifile. This entry will be followed by a line for each subfile.

Err	if the file cannot be opened.

The column is blank for a VOC entry with no data pathname.

The optional modes element of this command is a query processor WITH or WITHOUT clause using ENCRYPTION, REPLICATION or TRIGGER. For example,

LISTF WITH REPLICATION

would show only files that use replication.

The LPTR keyword will direct the output to the printer. Other query processor keywords can be appended to the command.