You can create a new DB2 table against which to run a query.
To create a table:
1. In the desired connection branch of the DB2 Web Query navigation tree, click Tables.
The Tables menu appears.
2. From the drop-down menu, select New.
The Table Definition page appears.
3. In the Creator field, enter the name of the table creator.
4. In the Name field, enter the name of the table.
5. In the In-Clause field, enter the name of the tablespace in which you want to create the table.
6. To add a column to the table, click Add Column.
DB2 Web Query adds a new column to the table.
Tip: To delete a column from the table, click the Select button next to the column you want to delete, and click Delete Column.
7. Specify the column options:
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. |
8. Click Next.
DB2 Web Query creates a DB2 table using the options you specified, and displays a confirmation message.
You can now select this table and run a query against it.