Previous Topic: Loading Multiple Tables Into a Data AreaNext Topic: LOAD/MASSADD Method


LOAD/BACKUP Method

  1. Load the first table using the LOAD function and back it up using the BACKUP function. Specify SEQ=NATIVE or SEQ=PHYSICAL. If SEQ=PHYSICAL is specified, RECID=NO must be entered. Load the next table and back it up. Continue to use the LOAD/BACKUP functions for each table you are loading. If the area is clustered, specify CLUSTER=DENSE for each load.
  2. After completing the last BACKUP, back up each table as a single file via a system utility, such as DITTO, SORT/MERGE, and so on. Use this file to load all the tables together.
  3. 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.