Creating a table without using a model

To create a new table without using a model (for instance, if no table already exists that is similar to the one you want to create):

1. Specify the name of the Db2® table you want to create in New Table.
2. Leave the owner and name of the model Db2® table in Model Table blank.
3. Select any of the Table Creation options 1–8 and press Enter. The default setting is Option 1 (Columns).
   Note: Before you can specify any of the table creation options 2, 4, 5, 6, 7, or 8, you must create at least some of the columns for the new table (using option 1).

   FM/Db2 validates your input and displays a panel that you use to enter information for the table creation option you have selected.

   For information about each table creation option, see Table Creation options.

4. Select the Table Creation option Create the table
5. Press Enter.
   FM/Db2 generates the following SQL statement:

   CREATE TABLE new_table_name other_details

   where other_details represents SQL clauses based on the details you have selected using the Table Creation options. FM/Db2 sends the generated SQL statement to Db2® and issues a message to confirm that it has been successfully run.
   Note: To view the generated SQL statement, either before or after it is issued, enter SQL on the command line.