Initialize Physical File Mbr (INZPFM)

Where allowed to run: All environments (*ALL)
Threadsafe: Conditional 		Parameters
Examples
Error messages

The Initialize Physical File Member (INZPFM) command initializes records in a member of a physical file to the specified type of record (either default or deleted records). If the initialized member is empty, records are added and initialized to the specified type; if the member is not empty, records of the specified type are added to the member. As many records are added as is necessary to make the total record count specified.

Restrictions:

Top

 

Parameters

Keyword Description Choices Notes
FILE Physical file Qualified object name Required, Positional 1
Qualifier 1: Physical file Name
Qualifier 2: Library Name, *LIBL, *CURLIB
MBR Member Name, *FIRST, *LAST Optional, Positional 2
RECORDS Initialize records as *DFT, *DLT Optional, Positional 3
TOTRCDS Total number of records 1-4294967288, *NXTINCR Optional

Top

 

Physical file (FILE)

Specifies the physical file that contains the member to be initialized.

This is a required parameter.

Qualifier 1: Physical file

name

Specify the name of physical file.

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 job is used to locate the file. If no library is specified as the current library, QGPL is used.

name

Specify the name of the library to be searched.

Top

 

Member (MBR)

Specifies the file member to be initialized.

*FIRST

The first member of the specified file is used.

*LAST

The last member of the specified physical file is initialized.

name

Specify the name of the physical file member to be initialized.

Top

 

Initialize records as (RECORDS)

Specifies the type of records that are initialized or added to the specified member. The records in the member are initialized as default records or deleted records.

*DFT

The records in the member are initialized as default records. If a default value was specified in the DDS (DFT keyword) for a field, that field is initialized to the specified default; otherwise, all numeric fields are initialized to zeros and all character fields are initialized to blanks.

*DLT

The records in the member are initialized as deleted records. The records are not eligible for access, but simply hold a place in the file. Deleted records are changed to reuse the deleted space.

Top

 

Total number of records (TOTRCDS)

Specifies the total number of records in the member after it is initialized. If the value specified in this parameter causes the size of the file to be larger than the size specified when the file was created, a message is sent to the system operator's message queue (QSYSOPR). The operator can either continue or cancel the operation.

*NXTINCR

The number of records in the member is increased to extend the file to the next allocation amount added. If the member is empty, records are added to meet the initial allocation specified for the member. *NXTINCR is not valid if *NOMAX was specified for the Member size (SIZE) parameter, when the file is created.

1-4294967288

Specify the total number of records you want the the member to have. If the number of existing records in the member already meets or is larger than this number, no records are initialized; if the number is less than that specified, enough records are initialized to equal the total specified.

Top

 

Examples 

 INZPFM   FILE(*CURLIB/INV)  TOTRCDS(12000)

This command initializes as many as 12,000 records in the first member of the physical file named INV in the job's current library *CURLIB. Only the number of records are added that brings the total to 12,000 records in the member. Any records that are added are initialized to the default format. If a default value is specified in the DDS (DFT keyword) for a field, that field is initialized to the specified default; otherwise, all numeric fields are initialized to zeros and all character fields are initialized to blanks.

Top

 

Error messages

*ESCAPE Messages

CPF3130

Member &2 already in use.

CPF3131

Cannot initialize member &2 with default records.

CPF3132

TOTRCDS parameter value either missing or too small.

CPF3133

File &1 in library &3 contains no members.

CPF3134

Referential constraint error processing member &2.

CPF3136

File &1 in &3 not allowed on command.

CPF3137

No authority to clear, initialize, or copy member &2.

CPF3138

Check constraint error processing member &2.

CPF3140

Initialize or copy of member &2 canceled.

CPF3141

Member &2 not found.

CPF3142

File &1 in library &3 not found.

CPF3143

Increments not allowed for member &2.

CPF3144

Member &2 not cleared or initialized.

CPF3148

New records need too much space for member &2.

CPF3156

File &1 in library &3 in use.

CPF3157

Triggers prevent requested operation.

CPF3159

Member &2 saved with STG(*FREE).

CPF3160

Operation on member &2 ended. Entry cannot be journaled.

CPF3179

Cannot clear or initialize DDM file &1 in &3.

CPF3180

Member &2 not initialized.

CPF32CF

Distributed file error, reason code &3.

CPF32C3

Distributed file error, level ID mismatch

CPF320B

Operation was not valid for database file &1.

CPF9801

Object &2 in library &3 not found.

CPF9810

Library &1 not found.

CPF9820

Not authorized to use library &1.

Top