Managing file groups
Overview
Permanent, Temporary and Ad-hoc Groups
Permanent Groups
Syntax
Temporary Groups
Syntax Differences from Permanent Groups
Ad-hoc Groups
Syntax
Using Groups
Files with large numbers of record
Postponing reorganizations with Groups
Note: the following technique cannot be used if there are references in your code to Internal Record Numbers (IRNs)
File X is almost full Define File Y, which looks like File X (same field names) File Y can be defined to have whatever table sizes it needs Group File X and Y together, with File Y as UPDTFILE Run your application against grouped files X and Y Example: CREATE PERM GROUP X FROM X, Y� PARAMETER UPDTFILE = Y� END