Select YES to load records into a non-empty table space, or NO to load records into an empty table space.

Specify YES or NO to load data into a non-empty or empty table space, respectively. If NO is specified, and the target table is not empty, no data is loaded.

Select to replace existing rows in all tables in the table space with newly loaded rows. (LOAD REPLACE)

If you reset the table space, select this check box to keep the compression dictionary, (KEEPDICTIONARY). If you do not select this box, a new dictionary will be built.

Select to load data into non-empty data sets. The data sets must be defined as VSAM REUSE.

Select to preformat table spaces and index spaces up to the high allocated RBA.

Select to write log records during the load process.

Select to ensure the utility will delete rows that have errors and issue an error message.

Select if you want to specify a format for input records.

Select to format input records to be compatible with DB2 unload format.

Select to format input records to be compatible with SQL/DS format.

Select to specify code page data type ASCII.

Select to specify code page data type EBCDIC.

Select to specify up to three coded character set identifiers.

Type a valid integer value for a single byte character set.

Type a valid integer value for a graphics and double byte character set.

Type a valid integer value for a double byte character set.

Select to specify the number of sort keys.

Type an integer value for the estimated number of sort keys. The default is 0.

Select to specify a continuation string for long records.

Type the start column number for the continuation string.

Type the end column number for the continuation string.

Specify this to define a character string.

Specify this to define a hexadecimal string.

Type a character string to use as the continuation string.

Type a hexadecimal string to use as the continuation string.

Select to specify that LOAD will not accept substitution characters in a string.

Type the name of a sequential, BSAM data set that contains data to be loaded. SYSREC is the data definition (DD) name that is associated with this data set name.

Type the name of a sequential, BSAM data set to use as a local primary copy data set. SYSCOPY is the data definition (DD) name that is associated with this data set name.

Type the name of a sequential, BSAM data set to use as a local backup copy data set.

Type the name of a sequential, BSAM data set to use as a primary copy data set at a recovery site.

Type the name of a sequential, BSAM data set to use as a backup copy data set to use at a recovery site.

Type the name of the temporary work files for the sort input data set. SYSUT1 is the data definition (DD) name that is associated with this data set name.

Type the name of the temporary work files for the sort output data set. SORTOUT is the data definition (DD) name that is associated with this data set name.

Type the name of a work data set that will store information regarding errors during load processing. SYSERR is the data definition (DD) name that is associated with this data set name.

Type the name of a work data set that will map the identifier of a table row back to the input record that caused an error.

Type the name of a sequential, BSAM data set that will contain copies of records that did not get loaded, and records loaded and then removed.

Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.

Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.

Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.

Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.

Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.

Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.

Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.

Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.

Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.

Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.

Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.

Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.

Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.

Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.

Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.

Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.

Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.

Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.

Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.

Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.

Type the maximum number of records to be written in the discard data set. The value can range from 0 to 2147483647. The default is 0.

Optional: Specify a device type for temporary data sets to be dynamically allocated by DFSORT. It can be any device type acceptable to the DYNALLOC parameter of the SORT or OPTION control statement for DFSORT. For example, if you do not specify a device type in this field and a sort is required, you must provide the DD statements that the sort program requires for the temporary data sets.

Type the number of dynamically allocated temporary data sets for DFSORT.

Select to specify DFSORT temporary data sets.

Shows the target tables defined for the table space. To add a table to this list, click the Add push button. To modify a table, select it and then click the Changepush button.

Shows the characteristics of specific fields in the target table. You can view the field definitions or select a field that you want to modify. To add a field to this table, click theAdd push button. To modify a field, select it and then click the Change push button.

Opens a window so that you can add a new target table to the list.

Opens a window so that you can change a target table in the list.

Removes a target table from the list.

Opens a window so that you can add a new field specification to the selected target table.

Opens a window so that you can change some characteristics of a field in the selected target table.

Removes a field specification from the selected table.

Submits the data in the notebook and closes the notebook. Available only when the required fields are completed.

Displays the SQL statements that are generated by your choices in this notebook.

Cancels any unsaved changes that you made and closes this notebook.