modulo Attribute Defining Item/BASIC: Syntax, modulo.def Definition/General, modulo Attribute Defining Item/BASIC: Syntax

modulo

Command modulo Attribute Defining Item/BASIC: Syntax
Applicable release versions: AP
Category BASIC: Syntax (110)
Description references attribute 3 of the file-defining item being processed by Access and describes the size of that file.
Syntax
Options
Example
Purpose
Related modulo.def
access.istat

modulo.def

Command modulo.def Definition/General
Applicable release versions: AP, R83
Category General (155)
Description designates the number of groups (measured in frames) in the primary file space, as indicated during the creation or reallocation of the file.

The modulo is always an integer remainder in the range 0 to modulo-1. The formula to determine the frame number of the initial frame of the group where the item is located is: fid=base+(item.id/modulo). This initial frame number is commonly called the "base fid".

The modulo of a file is a critical component of the "hashing" algorithm access method. It should never be altered in any file-defining item, as this can cause such problems as gfe's to appear.

During the full or account-restore processes, files are resized according to the optional modulo found in the "reallocation" attribute (attribute 13) of the file-defining item. After changing to the new modulo, all items must be re-hashed before they are replaced. This can cause restore processes (also t-load and copy) to run considerably slower.
Syntax
Options
Example
Purpose
Related hashing
tcl.create-file
tcl.item
modulo
hashing
item-id
access.t-load
full.restore
gfe.handler
primary.file.space
linked.overflow
frame
group
tcl.resize
tcl.f.modulo

modulo

Command modulo Attribute Defining Item/BASIC: Syntax
Applicable release versions: AP
Category BASIC: Syntax (110)
Description references attribute 3 of the file-defining item being processed by Access and describes the size of that file.
Syntax
Options
Example
Purpose
Related modulo.def
access.istat