Display RDB Directory Entries (DSPRDBDIRE)

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

Parameters

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

Entry (RDB)

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.

*ALL
All entries in the relational database directory.
generic-name
Specify the generic name of the relational database entries. A generic name is a character string that contains one or more characters followed by an asterisk (*).
name
Specify the name of the relational database directory entry.
Top

Output (OUTPUT)

Specifies whether the output from the command is displayed at the requesting work station or printed with the job's spooled output.

*
The output is displayed (if requested by an interactive job) or printed with the job's spooled output (if requested by a batch job).
*PRINT
The output is printed with the job's spooled output.
*OUTFILE
The output is directed to an output file.
Top

File to receive output (OUTFILE)

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

name
Specify the name of the database file to which the command output is directed.

Qualifier 2: Library

*LIBL
The library list is used to locate the file. If the file is not found, one is created in the current library. If no current library exists, the file will be created in the QGPL library.
*CURLIB
The current library for the thread is used to locate the file. If no library is specified as the current library for the thread, the QGPL library is used.
name
Specify the name of the library to be searched.
Top

Output member options (OUTMBR)

Specifies the name of the database file member that receives the output of the command.

Element 1: Member to receive output

*FIRST
The first member in the file receives the output. If OUTMBR(*FIRST) is specified and the member does not exist, the system creates a member with the name of the file specified for the File to receive output (OUTFILE) parameter. If the member already exists, you have the option to add new records to the end of the existing member or clear the member and then add the new records.
name
Specify the name of the file member that receives the output. If it does not exist, the system creates it.

Element 2: Replace or add records

*REPLACE
The system clears the existing member and adds the new records.
*ADD
The system adds the new records to the end of the existing records.
Top

Examples

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

Error messages

*ESCAPE Messages

CPF3EC3
Display relational database directory entry failed.
Top