Printing a data dictionary listing (pdes)¶
pdes [-clmn] filename [filename]…
Prints the contents of a data dictionary and associated secondary indexes, including the number of fields, number of key fields, key and record length, and the name, type and size of each field. An optional ‘long format’ allows even more detail about each field to be included. The information is normally output to the screen but may be redirected to a file or to a printer.
Each filename should be the name of a data dictionary file. The path should be included if the file is not located in the current working directory. The files are processed one by one in the order listed. The .d extension may, optionally, be included in the filename. This allows the form
to be used in order to print information about every data dictionary file in a directory.
Command line options.
The normal format, which is the default, is adequate for most purposes, including documentation. It prints the following for each data dictionary:
File nameNumber of fieldsNumber of key fieldsRecord lengthKey lengthNumber of indexes
For each fieldField nameType and sizeFormatHeading
Summary of indexes (list of index names)
For each indexMain file nameWhether maintained open or closedWhether null records stored
For each index fieldField nameType and sizeArray element to be stored (subscripted fields)Format
The long format prints the following additional information:
For each fieldValidation listHelp textComment textWhether hidden from SQLWhether sign reversed for SQL
The compressed format prints the header information as for the normal format, and then prints the information for each field on a single line in the format of a Sculptor !temp declaration.
New in version 6.3.3: See the new features.
The !record format exports the data dictionary as !record structure. This can be used as the display object in a table. Fields not to be displayed can be removed, headings changed, etc. This is useful when creating a table to display a subset of the fields. Can be used with other options as follows:
Substitutes the field names for the headings
Adds the validation list into the !record
Can’t read description of filename
The specified data dictionary cannot be found.
x: unknown option
The option -x is not valid for pdes.
Print normal listing of all files in directory, redirecting output to a file:
pdes *.d >datalist.txt
Print long listing of a single file to screen, paging output:
pdes -lm control
Print normal listing of two named files, without details of secondary indexes:
pdes -n stock labels