DB2DDL option
The following figure shows unloading of the data and creation of the DDL. You can specify the NAME clause to specify the table name optionally in the CREATE statement. 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.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*