FASTLOAD

The FASTLOAD utility loads data into a non-SQL defined database for the first time.

Authorization

To	You need this privilege	On
FASTLOAD into a segment	DBAWRITE	The segment

FASTLOAD Syntax

►►─── FASTLOAD ─┬──────────────────────┬──────────────────────────────────────►
                ├─ STEP ─┬─ step-name ─┘
                └─ FROM ─┘

 ►─┬──────────────────────────────┬───────────────────────────────────────────►
   └─ NOTIFY notify-record-count ─┘

 ►─────┬─────────────────┬────────────────┬─────────────────────┬─────────────►◄
       └── as SORTEXIT ──┘                └── REUSE workfiles ──┘

FASTLOAD Parameter

STEP

Specifies that only one step of the entire FASTLOAD process should be executed.

If you do not specify STEP, all steps are performed.

FROM

Specifies that FASTLOAD processing should begin at a specified step and that all remaining steps should be completed.

step-name

The name of the step to execute.

The name must be one of the following:

SORT1
IDMSDBL2
SORT3
IDMSDBL3
SORT4
IDMSDBL4

NOTIFY

Directs the FASTLOAD utility to send a message to the system console after a specified number of records are read in the current step.

If you omit the NOTIFY option or specify 0, no messages are sent. Only the standard messages that go to the SYSLST file are sent when a step is completed.

notify-record-count

The number of records to read before sending a message.

If you specify zero, the only message sent is the message that is always sent to the SYSLST file at the end of each step. The message indicates the number of records processed during the step.

as SORTEXIT

Causes each DBLx step in the utility to return its input data directly from the preceding sort instead of having the sort write the data to a workfile. This option eliminates one workfile for each sort and saves the I/O it takes to write then read the workfile.

REUSE workfiles

Causes each step in the utility to reuse an existing workfile, if possible, when writing its output data, instead of writing to a new one for each step. This reduces the number of workfiles that need to be allocated.