Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see UNLOAD PLUS for DB2 13.1.

SQL/DS-DDL option

If you specify CNTLCARDS SQL/DS DDL, UNLOAD PLUS generates appropriate CREATE TABLE DDL.

The following figure illustrates the unloading of the data and the creation of the DDL:


SQL_DS_DDL.png

You can optionally specify the table name used in the CREATE statement by specifying the 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.

Related topic

Control-statements-to-create-and-load-SQL-DS-tables

 

 

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