Input to the Loader utility consists of a configuration file and a data file. You launch the Loader utility as a single command string. In addition to specifying the configuration file and data file, you can optionally specify a record skip count and a record process count. If counts are included on the command line, they override any counts that are specified in the configuration file.

The command line has the following form:

E *SYSTEM/MCPSQL/LOADER ("<loader parameters>")

where <loader parameters> is defined as

── <configuration file name>, <data file name> ────────────────────────►
►─┬──────────────────────────────────────┬─────────────────────────────┤
  └─ ,<skip count> ─┬────────────────────┤
                    └─ ,<process count> ─┘

You can use a single run of the Loader utility to populate one table in the database from a single data file. The table must already be defined as part of the schema and might or might not be empty.

Using Skip and Process Counts

By using record skip and record process counts on the command line, you can have a single configuration file and single data file, and choose to load only portions of the data file at a time. Depending on the resources available on your server and without creating multiple configuration files, you can therefore use counts on the command line to load different portions of the same data file in parallel. Note that if you run parallel loaders, they work independently as far as configuration parameters such as max errors.

Example 1

The following example executes the Loader utility using the specified configuration file and data file, and the record skip and record process counts present in the configuration file (or the default counts if values are not specified in the configuration file).

E *SYSTEM/MCPSQL/LOADER ("LOADER/CONFIG/MYTABLE, 
                         (UC)MYTABLE/DATA ON MYPACK")

Example 2

The following example executes the Loader utility using the specified configuration file and data file, skips 10 records in the data file, and processes the number of records specified in the configuration file (or the default count if no value is specified in the configuration file).

E *SYSTEM/MCPSQL/LOADER ("LOADER/CONFIG/MYTABLE, 
                         (UC)MYTABLE/DATA ON MYPACK, 10")

Example 3

The following example executes the Loader utility using the specified configuration file and data file, skips 10 records in the data file, and then processes the next 100 records.

E *SYSTEM/MCPSQL/LOADER ("LOADER/CONFIG/MYTABLE, 
                         (UC)MYTABLE/DATA ON MYPACK, 10, 100")