LISTFR

The LISTFR command lists all files defined in the VOC that are remote to the account.

Format

LISTFR {modes} {LPTR}

The LISTFR command is a sentence to list all F type VOC entries referencing files that are remote to the account. Selection is performed by reporting only those records for which the data portion pathname contains a back slash. 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 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 file type column shows:

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

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

Dir	for a directory file.

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,

LISTFR 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.