LOAD (Build CXX or Data Area) › LOAD (Build a Data Area) › When to Use › Null Loading

Null Loading

If no data is required in any of the tables in the area prior to application task processing, all tables in the area can be prepared by performing a null load of the area (specify the parameter FORMAT=NONE). A null load is also useful to clear all tables in a data area. For example, you might design an application to store transactions for processing in tables in a data area.

Once all transactions have been processed, a null load of the area is more efficient to clear all transactions than deleting each of the individual transactions. As part of null loading a data area, CA Datacom/DB must search the Index for entries pointing to previous data in the area and delete those entries. This deletion occurs more rapidly and completely if the SORT keyword value is 1.