To create a new table

Restriction: This topic applies to Windows environments only.

From the main menu, click Run > Tools > Data Tools > SQL Option for DB2 > Client > SQL Wizard.
If the Catalog Browser window is not open, click to open it.
On the Catalog Browser window, ensure the Table tab is selected.
Click Create.
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.
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 +.
When you have finished, click OK to create the table.