| Where allowed to run: All environments (*ALL) Threadsafe: No |
Parameters Examples Error messages |
The Display Relational Database Directory Entry (DSPRDBDIRE) command allows you to display one entry, generic entries, or all entries in the relational database (RDB) directory.
| Top |
| Keyword | Description | Choices | Notes |
|---|---|---|---|
| RDB | Entry | Generic name, name, *ALL | Optional, Positional 1 |
| OUTPUT | Output | *, *PRINT, *OUTFILE | Optional, Positional 2 |
| OUTFILE | File to receive output | Qualified object name | Optional |
| Qualifier 1: File to receive output | Name | ||
| Qualifier 2: Library | Name, *LIBL, *CURLIB | ||
| OUTMBR | Output member options | Element list | Optional |
| Element 1: Member to receive output | Name, *FIRST | ||
| Element 2: Replace or add records | *REPLACE, *ADD |
| Top |
Specifies the relational database directory entry. If an entry has no alias, the relational database name is used as the entry name. If an entry has an alias, the alias is used as the entry name.
| Top |
Specifies whether the output from the command is displayed at the requesting work station or printed with the job's spooled output.
| Top |
Specifies the database file to which the output of the command is directed. If the file does not exist, this command creates a database file in the specified library. If the file is created, the public authority for the file is the same as the create authority specified for the library in which the file is created. Use the Display Library Description (DSPLIBD) command to show the library's create authority.
If a new file is created, system file QADSPDE in system library QSYS with a record format name of RWRDDSP is used as a model. If the file already exists, it must have this format.
Qualifier 1: File to receive output
Qualifier 2: Library
| Top |
Specifies the name of the database file member that receives the output of the command.
Element 1: Member to receive output
Element 2: Replace or add records
| Top |
Example 1: Directing Information to a Spooled File
DSPRDBDIRE OUTPUT(*PRINT)
This command directs information from all of the relational database directory entries to a spooled file.
Example 2: Directing Information to a Database File
DSPRDBDIRE OUTPUT(*OUTFILE) OUTFILE(SAVEDIR)
This command directs all of the relational database directory entries to an output file named SAVEDIR. This is the usual method for backing up the contents of the relational database directory. The entries can be restored using a CL program that reads the information from the output file and issues Add Relational Database Directory Entry (ADDRDBDIRE) commands to add the information back into the relational database directory.
| Top |
| Top |