4.9.7 Changing the Number of Records in an RMSfile

You can change the maximum number of records in a hashed RMSfile with toolkit as follows:

gifs/20000000.gif Start toolkit on your database:

c:\> toolkit dbname

gifs/20000000.gif Select 1 - Data Files Menu from the Toolkit Development Menu.

gifs/20000000.gif Select M1 - Expand Capacity of Data File from the Data File Menu.

gifs/20000000.gif Enter the logical RMSfile name.

gifs/20000000.gif Enter the new number of records (see below for the format of this number).

gifs/20000000.gif Press STORE <F5> to change the size of the RMSfile or CANCEL<F1>-X to leave the RMSfile unchanged.

You can change the size of a hashed RMSfile with the following command:

c:\> expandlf lfname #records

Lfname is the logical name of the RMSfile. #records is the new maximum number of records.

The number of records, #records, can be written one of three ways:

+n increases the number of records in the RMSfile by n (e.g., +500 means 500 more records than the current maximum number of records)

-n decreases the number of records in the RMSfile by n (e.g., -200 means 200 fewer records than the current maximum number of records)

n sets the number of records in the RMSfile to n

The actual number of records is adjusted upwards to the nearest prime number.

Changing the maximum number of records for Indexed or sequential RMSfiles is ineffective, since they automatically grow as you insert records.