DB2 graphic QMF Version 8

File menu

New

Opens the New window where you can select the type of query document that you want to create.

Table 2. Options on File Menu
Field Description
Query To create a new SQL query. You select Query if you will be creating the query by typing the SQL statements in the window directly or using one of the interfaces. The available interfaces include the prompted, diagram, or natural views.
OLAP Query To create an OLAP query. OLAP queries can only be run against database servers that support DB2 Cube Views.
Form Contains the formatting instructions that QMF for Windows uses to generate a report from query results.
Procedure A set of commands used to run queries, print reports, import and export data, and perform other functions with a single command.
List A list of objects (query, form, procedure or table) based on a filter, such as an object owner, object name, or object type.
Job A file used to schedule and run unattended procedures. A job file can store a user ID, encrypted password, and substitution variables.
Map Create a new spatial data map document
Layout Create a new visual representation of the data in a layout document that includes many chart variations
Visual Report Create a new report document using the visual report interface

Open

Opens an Open file window where you can select from a list of available files, the file that you want to open. The list of available files that you can open in QMF for Windows includes:

Open from server

Select this option to open an existing query, form, or procedure, or list file that has been saved on the database server

Draw query

Select this option to create a query document based on the query type and tables you specify.

Note:
This menu command is the same as the DRAW command in host QMF.
Table 3. Fields on Draw Query Window
Field Description
Server The database server where the tables for the query are stored
Query type The type of query to create:
  • SELECT
    • create an SQL SELECT statement for the tables
      Note:
      More than one table can be selected for an SELECT statement.
  • UPDATE
    • create an SQL UPDATE statement for the table.
      Note:
      Only one table can be selected for an UPDATE statement.
  • INSERT
    • create an SQL INSERT statement for the table.
      Note:
      Only one table can be selected for an INSERT statement.
Owner The table owner (in the correct format for identifiers) for the query
Name The table name (in the correct format for identifiers) for the query
Identifier The correlation ID for a table in the query
Note:
If left blank, a correlation ID is generated automatically.
Tables The table or tables to include in the query
Note:
More than one table can be specified for a SELECT statement.

Only one table can be specified for an UPDATE or INSERT statement.

Table Editor

Select this option to search for and edit rows in a table. Select File--> Table Editor or List--> Edit to use the Table Editor.

Table 4. Fields on Table Editor Window
Field Description
Server The database server where the table is stored
Table owner The user who created the table
Table name The table to search for
Save Mode

Indicates whether to save changes with each row or when changes are complete:

  • Immediate

    The table will be updated at the server immediately after each change.

  • End

    The table will be updated at the server after you finish entering all changes.

    Note:
    If you select "End" as the save mode, other users are prevented from making changes to the table until the final changes are committed.
Edit Click Edit to update a table in the database.
List Tables Click List Tables to open the Tables dialog box that lists the tables owned by the specified owner. Select a table from the list and click OK to edit the table.

Optional: The Set User Information dialog box opens when you click List Tables if you are not connected to the database. Use this dialog box to provide required user connectivity information to the database.

Edit If you know the table name, click Edit to open the Edit Table dialog box. Use this dialog box to search for, update, insert or delete a row for the owner and server

Import data

Select this option to import data from an *.ixf or dBASE file into a new query document.

Recently Used files

Use this option to open local files that were accessed recently.

  1. Click File--> Recent Files.

    The Recent Files menu opens.

  2. Select a file from the list of files.

    The file data opens in a new dialog box.

    Note:
    There is no toolbar button for the Recent Files menu option.

Recently Used objects

Select this option to open objects on the server that were accessed recently. The format of the most recently accessed object is:

SERVER:OBJECT_TYPE:OWNER.NAME
  1. Click File--> Recent Objects.

    The Recent Objects menu opens.

  2. Select the object from the list of objects.

    The object data opens in a new dialog box.

    Note:
    There is no toolbar button for the Recent Objects menu option.

Terminate connections

Select this option to end the connection to the server.

Exit

Select this option to close QMF for Windows.


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