Display Physical File Member (DSPPFM)

Where allowed to run: Interactive environments (*INTERACT *IPGM *IREXX *EXEC) Threadsafe: No

Parameters Examples Error messages

The Display Physical File Member (DSPPFM) command displays a physical database file member. Records are shown in arrival sequence, even if the file has a keyed access path. You can page through the file, locate a particular record by record number, or specify a starting position in the record. You can also select a character or hexadecimal display of the records.

Top

---

 

Parameters

Keyword	Description	Choices	Notes
FILE	File	Qualified object name	Required, Positional 1
	Qualifier 1: File	Name
	Qualifier 2: Library	Name, *LIBL, *CURLIB
MBR	Member	Name, *FIRST, *LAST	Optional, Positional 2
FROMRCD	From record	Unsigned integer, 1, *END, *ALLDATA	Optional

Top

 

File (FILE)

Specifies the name and library of the physical file containing the member to be displayed.

This is a required parameter.

Qualifier 2: Library

*LIBL

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

*CURLIB

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

name

Specify the name of the library to be searched.

Top

 

Member (MBR)

Specifies the name of the file member displayed.

*FIRST

The first member of the specified physical file is displayed.

*LAST

The last member of the specified physical file is displayed.

member-name

Specify the name of the file member.

Top

 

From record (FROMRCD)

Specifies which record in a physical file is shown on the top line of the initial display. If the specified record number is a deleted record, the display is positioned on the first record that follows the record that has been deleted. You can display as many records as needed using the page-up and page-down keys.

The possible values are:

1

Record number one, or the first non-deleted record, of the physical file is shown. If the file is a distributed file, this will be the first non-deleted record of the local member, and only local data will be shown.

*END

The last non-deleted record in the physical file is shown. The *END value shows the last complete page so that the last record in the physical file appears at the bottom of the screen. If the file is a distributed file, this will be the last non-deleted record of the local member, and only local data will be shown.

*ALLDATA

All the data for a distributed file, including remote data, is shown. If *ALLDATA is specified for a non-distributed file, it will be treated the same as FROMRCD(1).

record-number

Specify the number of the record shown on the top line of the initial display. If the file is a distributed file, this will be the record number of the local member, and only local data will be shown.

Top

---

 

Examples

Example 1: Displaying the First File Member

 DSPPFM   FILE(TESTA)

This command shows the first member of a physical file named TESTA. The library list is used to locate the file.

Example 2: Displaying a File Member

 DSPPFM   FILE(SAMPLE/TESTB)  MBR(PROGRAM)

This command shows member PROGRAM of physical file TESTB in library SAMPLE.

Top

---

 

Error messages

*ESCAPE Messages

CPF8056

File &1 in &2 not a physical file.

CPF9810

Library &1 not found.

CPF9812

File &1 in library &2 not found.

CPF9820

Not authorized to use library &1.

CPF9822

Not authorized to file &1 in library &2.

CPF9845

Error occurred while opening file &1.

CPF9846

Error while processing file &1 in library &2.

CPF9847

Error occurred while closing file &1 in library &2.

Top