LOAD (Build CXX or Data Area) › LOAD (Build a Data Area) › Adding a Table to a Data Area Not Using REPLACE

Adding a Table to a Data Area Not Using REPLACE

To add a table to an existing area that already contains one or more tables:

1. Create a backup of the area using the BACKUP function. Specify SEQ=NATIVE or SEQ=PHYSICAL. If SEQ=PHYSICAL is specified, RECID=NO must be entered.
2. Load the new table into the area with LOAD.
3. Back up the area using BACKUP. Specify SEQ=NATIVE or SEQ=PHYSICAL. If SEQ=PHYSICAL is specified, RECID=NO must be entered.
4. Concatenate the two BACKUP files into one LOAD operation.
5. If any of these tables share a Native Key ID or if the area is clustered, then you must do one additional backup with SEQ=NATIVE, and then load it to cluster the tables. If the area is clustered, specify CLUSTER=SPARSE.