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

  1. Follow the steps in Creating a query to display the Query-Definition window.
  2. 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.

  3. 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.
    Figure 1: The Column Selection window after selecting a table

    begin figure description - This figure is described in the surrounding text. - end figure description
  4. 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.
    Figure 2: Columns selected from a table

    begin figure description - This figure is described in the surrounding text. - end figure description
  5. 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
  6. 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.
    Figure 3: The Query-Definition window after using the table button

    begin figure description - This figure is described in the surrounding text. - end figure description
  7. Repeat steps 2 through 6 to add columns from other tables.
  8. Modify the text in the Where text box so that it is a valid WHERE clause.
    See Editing the WHERE clause.
  9. Click OK to save the query and return to the Query window.
  10. Click Cancel to return to the HPL window.