SQL/DS-LOAD option

The following figure displays the SQL/DS-LOAD option:

If you specify CNTLCARDS SQL/DS-LOAD, UNLOAD PLUS generates a DATA LOAD utility statement. This statement can be used to load data from the unloaded sequential file into an existing SQL/DS table on a VM system using the SQL/DS DATA LOAD utility.

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

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 or if you do not specify the INTO command option, UNLOAD PLUS uses the column names of the unloaded columns. The data types of the columns in the table that is being created match the unloaded column types unless UNLOAD PLUS converts them during the unload.

If you have added any new constant fields during unload processing, UNLOAD PLUS assigns field names using the format $CONSTn, where n is 1 for the first field created and is incremented by one for each additional field created.

Any NULL columns processed by UNLOAD PLUS during unload processing 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.