Lists all dictionaries, data sections and index sections defined from a particular account or specified dictionary.
Cataloged DataBasic program.
LISTFILES {/accountName/}{fileDict} {fileTypes} {(options}
/accountName/ The name of an account for which each file and data section will be listed.
The initial slash character must be included unless the current MD contains a Q-pointer to the required account. The trailing slash character can be omitted if there is no file name.
fileDict The name of a file for which the data sections will be listed.
To list data sections for a file in another account, use /accountName/fileDict.
If neither accountName nor fileName is specified, LISTFILES defaults to the current MD.
fileTypes One or more letters, each specifying a file type as defined in Ftype below. There must be no spaces between the letters. Filters the output to include only the specified file types.
If this parameter is included, the T option must also be specified.
P Sends the listing to the printer.
T Specifies that the fileTypes parameter has been included.
Each dictionary name is listed with associated data sections listed below, indented by one space. Indexes are listed below associated data sections, indented by two spaces.
The following information is displayed:
File name The name of each file.
Type The type of D/CODE.
Ftype Type of file. This is defined by two characters; a letter and a number. The letter can be:
A A clean log binary data section.
B A byte stream file. (A ‘normal’ Reality file.)
C A clean log user view data section.
D A directory view.
E A special file created with the MAKE-SPECIAL command.
F A file on a foreign database.
G An SQL view.
H An automatically sized data section.
S An automatically sized data section for which automatic sizing has been suspended with AFS-HOLD.
The number can be:
1 Master dictionary.
2 File dictionary.
3 Data section.
4 Index section.
Mod Depends on the type of file:
Directory view The path to the host directory or folder.
Special file The special file type and any additional parameters.
Foreign database The data source name and user-id.
SQL view The data source name and user-id.
Automatically sized data sections
The default modulo (that is, the modulo assigned when data section was created
or converted to automatic sizing).
Otherwise, shows the modulo of the file.
Details Depends on the type of file:
Directory view Blank.
Special file Blank.
Foreign database Blank.
SQL view The name of the SQL table.
Automatically sized data
sections
The number of groups currently in the file.
Otherwise, shows the separation of the file (always 1).
Just Depends on the type of file:
Directory view and special file
Blank.
Otherwise, shows the type of alignment (L or R).
Len Depends on the type of file:
Directory view and special file
Blank.
Otherwise, shows the number of columns for output.
LISTFILES
Lists all the files in the current account, together with their data sections.
LISTFILES MYFILE
Lists the data sections for the file MYFILE.
LISTFILES /MYACC
Lists the files and data sections in the account MYACC.
LISTFILES bd (T
Lists only normal Reality files and directory views in the current account.
LISTFILES /MYACC hs (T
Lists all automatically sized data sections in the account MYACC.
File definition items in file: TESTACC Page 1 File name Type Ftype Mod Details Just Len TAB2 D B2 1 1 L 10 TAB2 DY G3 dbora,bob TAB2 L 10 TEMP D B2 1 1 L 10 TEMP DY D3 /Temp LOCAL DL B2 1 1 L 10 DATA2 DL B3 11 1 L 10 LOCAL DL B3 11 1 L 10 X1 D B4 7 1 L 10 ORACLE DL F2 dbora,bob L 10 ORA2 DL F3 dbora,bob L 10 ORACLE DL F3 dbora,bob L 10 X1 D F4 dbora,bob L 10 T1 DL B2 1 1 L 10 T1 DL H3 7 134 L 10
In this report: