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.

This is a required parameter.

The possible values are:

*ALL

All entries in the relational database directory.

generic*-relational-database-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 (*).

relational-database-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 possible values are:

*

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 name and library of the output file to which the output of this command is directed. If the file does not exist, it is created. 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.

This parameter is valid only if you specify *OUTFILE on the Output prompt (OUTPUT parameter).

The possible library values are:

*LIBL

All libraries in the library list for the current thread are searched until the first match is found.

*CURLIB

The current library is used to locate the output file. If no library is specified as the current library for the job, QGPL is used.

library-name

Specify the name of the library in which the output file is to be located.

database-file-name

Specify the name of the file in which the output is to be located.

Top

 

Output member options (OUTMBR)

Specifies the name of the database file member to which the output is directed when *OUTFILE is specified for the Output (OUTPUT) parameter.

The possible member to receive output values are:

*FIRST

The first member of the specified file is used.

member-name

Specify a maximum of 10 characters for the name of the output file member in which the requested information is to be located.

The possible replace or add records values are:

*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 an Output 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 an Output 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