Using the Column Selection window
The Table button displays the Column Selection window. You can use the Column Selection window to build queries by selecting tables and columns. The ipload utility inserts the selected columns and tables into the appropriate text boxes of the Query-Definition window.
About this task
To use the Column Selection window:
Procedure
- Follow the steps in Creating a query to display the Query-Definition window.
-
Click Table.
The Column Selection window appears, as The Column Selection window after selecting a table 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 pane displays a list of the columns in that table. The following query shows the Column Selection window with the customer table selected.
-
Select one or more columns to use in the query.
- To select a single column, select that column.
- To select all columns, click Select All.
- To select consecutive columns, select the first column. Move to the final column and hold down SHIFT while you select that column.
- To select nonconsecutive columns, select a column. Hold down CONTROL while you select additional items.
The following figure 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.
The following figure 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.