DB2LOAD option

The following figure displays using the DB2LOAD option:

INTO option

If you specify a table name in the INTO NAME clause, UNLOAD PLUS uses that table name in the LOAD statement. If you do not supply a table name, UNLOAD PLUS uses the name of the table from which it unloaded the data.

You can use the INTO list of columns to specify column names for the table that is being created. If you do not supply a list of columns, UNLOAD PLUS uses the column names of the unloaded columns. The data types of the columns in the table being created match the unloaded column types unless UNLOAD PLUS converts them during the unload.

You can specify a string following the INTO statement to supply additional command options for the LOAD statement. For example, you might want to specify certain partitions to replace:

For information about specifying additional command options with the CNTLCARDS DB2LOAD option, see  Inserting additional command options into utility control statements.

Adding new fields

If you added any new constant fields during unload processing, UNLOAD PLUS uses the format $CONSTn to assign field names, where n is 1 for the first field that UNLOAD PLUS creates, and is incremented by one for each additional field that it creates.

Any NULL columns that UNLOAD PLUS processed while unloading create a field named NULLn following the nullable field, where n is 1 for the first field created and is incremented by one for each additional field created. If this field contains a question mark (?) character, its associated field is null. Because these field names exist, the LOAD statement cannot specify SKIPFIELDS NO.