DB2 graphic QMF Version 8

Drawing SQL queries - by matching patterns

  1. Select File--> Draw Query.

    The Draw Query dialog box opens.

  2. Specify the server where the tables are stored.
  3. Select the query type:
    Table 24. Select Query Type
    Query Type Result
    SELECT Retrieve rows from one or more tables
    UPDATE Change information in a table.
    Note:
    Select only one table. Otherwise, this message displays:

    You cannot draw an Update or Insert query for more than one table at a time. Remove all but one of the tables from the table list.

    INSERT Add new rows to a table
    Note:
    Select only one table. Otherwise, this message displays:

    You cannot draw an Update or Insert query for more than one table at a time. Remove all but one of the tables from the table list.

  4. Type a pattern to locate the table.

    Patterns enable you to search for table names from a list of matching tables. There are two types of search patterns:

  5. Click Add from List.
  6. Select a table from the list.
  7. Click OK.
  8. Type a unique identifier for the table.
  9. Click Add.

    The table is added to the query.

  10. Click OK.

    The SQL for the selected table or tables is created and displayed. You can edit the SQL.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004