You can select an existing DB2 table, and create a new DB2 table based on it.
To create a similar table:
1. In the desired connection branch of the DB2 Web Query navigation tree, click Tables.
The Tables branch expands, listing the available DB2 tables.
2. Select the table on which you want to base the new table.
A drop-down menu appears.
3. From the drop-down menu, select Create Like.
The Table Definition page appears, and displays the column information for the table you selected.
4. In the Creator field, enter the name of the table creator.
5. In the Name field, enter the name of the new table.
6. In the In-Clause field, enter the name of the tablespace in which you want to create the new table.
7. To add a column to the table, click Add Column.
DB2 Web Query adds a new column to the table.
8. To delete a column from the table, click the Select button next to the column you want to delete, and click Delete Column.
DB2 Web Query deletes the column from the table.
9. If you wish, edit the column options for the new table:
Name |
Specify the name of the column |
Type |
Specify the type of data which will populate the column, such as integer or decimal. |
L,P |
Specify the maximum allowable length and precision of the data, where applicable. The length indicates how many integer places the data may have; the precision indicates how many decimal places the data may have. For example, a length and precision specified as 10,2 results in a maximum number of 10 integer places, and 2 decimal places. |
Extra |
Specify any additional DB2-allowable attributes to add to the column definition, such as Not Null, or a default value. |
10. Click Refresh to see the columns and options you specified.
11. Click Next.
DB2 Web Query creates a new DB2 table using the options you specified, and displays a confirmation message.
You can now select this table and perform a variety of actions against it.