To modify parameters for a file
Select option "M" (modify file parameters).
Specify the number of the file to be modified.
If the file is protected, supply the password.
Press ENTER.
The Modify File Parameters screen is displayed:
10:19:39 ***** A D A B A S BASIC SERVICES ***** 2005-11-22
DBID 1955 - Modify File Parameters - PFLM002
File No. ... 1
File Name .. EMPLOYEES
-----------------------------------------------------------------------------
Max. Allocation
ASSO PFAC ...... 10 UI Blks per extent .. 0
DATA PFAC ...... 10 NI Blks per extent .. 0
Max. RECL ...... 4816 DS Blks per extent .. 0
New File Name .. EMPLOYEES______ ISN Reuse ............. OFF
New File No. ... 1 with RESET ..... ___
in Parallel .... NO
User ISN ....... OFF DS Reuse .............. ON_
with RESET ..... ON_
File Password .. in Parallel
Mixed DS Device........ OFF
AlphaNum Encoding .. 0 Program Refresh ....... OFF
WideChar Encoding .. 0
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Men |
This function corresponds to the utility function ADADBS MODFCB.
The equivalent direct command is
MODIFY FILE file-number
This document covers the following topics:
You can use the Modify File Parameters screen to change the Associator and Data Storage padding factors for the file, the maximum number of blocks that can be allocated (for a new Data Storage, normal index, or upper index extent), and the maximum compressed record length allowed.
The "padding factor" is the percentage (%) of each Associator or Data Storage block that is reserved; that is, not loaded. This area is used to create new records later. The range is from 3 to 90 percent. The factor size allocated should depend on the amount of updating that is expected. The number of bytes left in the Associator after padding must exceed the largest descriptor value by at least 10.
On the same Modify File Parameters screen, you can change the name or number of the file using the New File Name or New File No fields.
The equivalent direct commands are
RENAME FILE file-number
RENUMBER FILE file-number
You can also turn off or on several file options on this screen:
User ISN ISN Reuse ...with RESET Data Storage Reuse ...with RESET Mix Data Storage Dev Program Refresh
ISN Reuse and Data Storage Reuse determine whether ISNs and Data Storage blocks for deleted records are reused as new records are added to the file. The equivalent direct commands are
REUSE ISNS file-number
REUSE DS file-number
When setting either of these two options to "ON", you can also set the RESET option "ON" to start the search for an unused ISN and/or Data Storage block at the beginning of the file.
If the file was loaded using universal encoding support (UES), the code values may be changed on this screen.
