- Follow the steps in Creating a Query to display the query-definition window (Figure 77).
-
Click Table.
The Column Selection window appears, as Figure 78 shows. The Tables list box includes synonyms and views that are valid for the local database server.
- Select a table.
After you select a table, the right-hand pane displays a list of the columns in that table. Figure 78 shows the Column Selection window with the customer table selected.
- Select one or more columns to use in the query.
Use the following actions to select columns.
- To Select
- Perform This Action
- A single column
- Select that column.
- All columns
- Click Select All.
- Consecutive columns
- Select the first column. Move to the final column and hold down SHIFT while you select that column.
- Nonconsecutive columns
- Select a column. Hold down CONTROL while you select additional items.
Figure 79 shows the Column Selection window with several columns selected.
- When you finish selecting columns, click OK to
return to the query-definition window.
When the query-definition window reappears, the mouse cursor changes to a pointing hand and the message line reads:
Position Cursor Where Column Data to be Inserted
-
Select the Select text
box or the Where text box.
Figure 80 shows columns inserted into the Select text box. The ipload utility also inserts the table name into the From text box.
- Repeat steps 2 through 6 to add columns from other tables.
- Modify the text in the Where text box so that it is a valid WHERE clause.
- Click OK to save the query and return to the Query window.
- Click Cancel to return to the HPL window.
