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:
- query files (*.qry)
- queries saved in the prompted view files (*.pq)
- natural query files (*.nq)
- OLAP query files (*.oq)
- form files (*.frm)
- procedure files (*.prc)
- object list files (*.ol)
- map files (*.spm)
- job definition files (*.jdf)
- Layout files(*.vly)
- Visionary World files (*.vis)
- Visual report(*.vr) files
- IXF files (*.ixf)
- dbase III files (*.dbf)
- Web Query Markup Language files(*.wqml)
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:
|
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.
- Click File--> Recent Files.
The Recent Files menu opens.
- 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
- Click File--> Recent Objects.
The Recent Objects menu opens.
- 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.
