Skip to Content

SQL/DS option

If you specify CNTLCARDS SQL/DS, UNLOAD PLUS generates appropriate CREATE TABLE DDL and DATA LOAD utility statements.

Before the data can be reloaded, the CREATE TABLE DDL and the DATA LOAD utility statement must be processed separately.

Related topic

Control statements to create and load SQL/DS tables

You can optionally specify the table name used in the CREATE statement by specifying the INTO NAME clause. If you do not supply a table name, UNLOAD PLUS uses the name of the unloaded table.

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.

In the case of DATE, TIME, or TIMESTAMP columns, the column definition retains the original column type. The DATA LOAD utility statement for these types will be DATE, TIME, or TIMESTAMP EXTERNAL.

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.

Following the CREATE TABLE DDL, UNLOAD PLUS generates a DATA LOAD TABLE utility statement. This statement is used to load data from the unloaded sequential file into the SQL/DS table named in the CREATE TABLE statement by using the SQL/DS DATA LOAD utility.

 

SQL_DS.png

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

UNLOAD PLUS for DB2 13.1