DB2 graphic QMF Version 8

Drawing SQL queries - by table name

  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 23. Query types
    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 the table owner and name.
  5. Click Add.
  6. Click OK.

    This creates and displays an SQL query for the selected tables. 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