MAINTAIN ASF › Examples

Examples

Examples of the MAINTAIN ASF input parameters follow:

Example 1

The input parameters shown below direct MAINTAIN ASF to load the data in the input file as rows of the data table with table definition number 119. By default, MAINTAIN ASF connects only automatic indexes associated with the data table.

SUBSCHEMA=RU000119
LOAD TDN=119

Example 2

The input parameters shown below direct MAINTAIN ASF to load the data in the input file as rows of the data table with table definition number 183. Because CONNECT is specified, MAINTAIN ASF connects all indexes associated with the data table.

SUBSCHEMA=RU000183
EXTEND TDN=183,CONNECT

Example 3

The following command directs MAINTAIN ASF to load the table "114" using input read from ASFIPT01. The steps used to build the index on the table will run as a sortexit and will reuse workfiles:

MAINTAIN ASF IN SEGMENT ASFDICT USING RU000114
AS SORTEXIT REUSE WORKFILES
LOAD TABLE "114" INPUT ASFIPT01;