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:
- This command is conditionally threadsafe. In multithreaded jobs, this command is not threadsafe and fails for Distributed Data Management (DDM) files of type *SNA.
| 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 or the system-period temporal table 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 |