To create a new table

Restriction: This topic applies to Windows environments only.
  1. From the main menu, click Run > Tools > Data Tools > SQL Option for DB2 > Client > SQL Wizard.
  2. If the Catalog Browser window is not open, click * to open it.
  3. On the Catalog Browser window, ensure the Table tab is selected.
  4. Click Create.
  5. Type a name for the table in Table Name.

    If you use a three-part table name and the location is not the current one, a temporary connection to the new location is established.

  6. Define the columns (fields) in your table by typing a column name, data type, length and whether nulls are accepted in the appropriate fields.

    To define a new column, click +.

  7. When you have finished, click OK to create the table.
Parent topic: Manage Databases