View menu
Natural
Click Natural to display the active query in
the natural query view. This command is only available if the active
query was created or saved as a natural query and EasyAsk software
is installed.
Prompted
Click Prompted to display the active query in
the prompted query view. This command is only available if the active
query was created or saved in the prompted view.
SQL
Click SQL to view the SQL statements for all
queries, including queries created using the diagram, natural or
prompted views.
Diagram
Click Diagram to display the active query in
the diagram query view. This command is only available if the active
query was created or saved in the diagram view.
Results
Click Results to view the query results in the
active window. This command is only available if there are query
results available and the active window currently displays a query
in the SQL, prompted, or diagram views.
Parameters
Displays the parameters returned by running a stored procedure.
This command is only available if the stored procedure has input
or output parameters.
Result Set List
Lists the result sets returned by running a stored procedure.
Up to four result sets can be listed. Click on the number or the
name of the result set that you want to display. This command is
only available if the query results are from running a stored procedure.
More Result Sets
Opens the Results Sets window where all the result sets
from running a stored procedure are listed. You can select the result
set that you want to display. This command is only available if
the query results are from running a stored procedure.
Resource Limits
Select Resource Limits to view the
resource limits that have been specified for your user ID. Resource
limits are set by the QMF for Windows Administrator. They control
users access to database servers and resource usage.
The following types of limits and controls can be set by the
QMF for Windows Administrator:
- Timeouts
- Limits
- SQL verbs
- Options
- Save data
- Binding
- Object tracking
- LOB options
- Report Center
Although the majority of resource limits set up for the database
server are display-only, you can set certain limits while running
a query, as described in "Setting your own row limit."
Setting your own row limit
Prior to submitting a query that you suspect will be time
consuming or resource consuming, you can specify the maximum number
of rows to retrieve. QMF for Windows will cancel the query when
it reaches this row limit.
Note:
The Maximum Rows To Fetch and Maximum Bytes to Fetch parameters specified
by the System Administrator for your resource limits group take
precedence over the row limit parameter you specify here.
- Select Query--> Set Row Limit.
The Set Row Limit dialog box opens.
- In the Enter the maximum number of rows to retrieve for this query field, type
the maximum number of rows that the query can return.
Optional: Type a zero indicate no limit.
- Click OK.
The row limit is applied the next time you run the query.
Note:
Rows retrieved in excess of the specified row limit
are retained and they can be viewed.
Connections
Click View--> Connections to
open the Connection Information dialog box. This dialog box lists
the servers and the number of connections between QMF for Windows
and the database servers. You can open this dialog box at any time, even
while working in QMF for Windows.
Table 5. Fields on Connections Window
Field |
Description |
Servers and Connections |
This dialog box lists the servers connected to
QMF for Windows and identifies the number of connections that QMF for
Windows has to each server. |
Show details |
Click Show Details to obtain
detailed information on each connection to a server in the Servers
and Connections list.
The Connection Details dialog box opens. This dialog box provides
information about the server connection, the user ID, the connection
state, connection statistics, and the method of connectivity |
Global variables
Displays all local global variables. Click View--> Global Variables to
open the Global Variables dialog box. Certain global variables are
system-level, meaning you cannot change them. These global variables
report on the state of the system; automate selections during procedures
(such as exporting data in a specific format); supply values for
substitution variables in a procedure; and pass information between
procedures.
Table 6. Fields on Global Variables Dialog Box
Field |
Description |
Name |
The name of the global variable. Each global
variable has a prefix. For example, global variables prefixed with AO are system-level
variables and cannot be changed; while, many global variables prefixed
with QW are QMF for Windows variables that
can be set. |
Value |
The value held by the global variable. |
Toolbars
Click View--> Toolbars to
open the Toolbars window. The Toolbars window lists the toolbars
available to QMF for Windows. Check or uncheck the toolbars that
you want to use.
Toolbars are initially docked at the top of each window, although,
you can grab on to the toolbar and move the toolbar around the screen.
Table 7. Fields on Toolbars Window
Field |
Description |
Main toolbar |
Check the Main toolbar check
box to make the options on the Main toolbar available. |
Query toolbar |
Check the Query toolbar check
box to make the options on the Query toolbar available when you
work with a query. |
Natural query toolbar |
Check the Natural Query toolbar check
box to make the options on the Natural Query toolbar available when
you work with a natural query.
Note:
EasyAsk software must be available for this option. |
Job toolbar |
Check the Job toolbar check
box to make the options on the Job toolbar available when you work
with a job. |
Query Results toolbar |
Check the Query Results toolbar check
box to make the options on the Query Results toolbar available when
you work with query results. |
Procedure toolbar |
Check the Procedure toolbar check
box to make the options on the Procedure toolbar available when
you work with a procedure. |
Form toolbar |
Check the Form toolbar check
box to make the options on the Form toolbar available when you work
with a form. |
List toolbar |
Check the List toolbar check
box to make the options on the List toolbar available when you work
with a list. |
Map toolbar |
Click Map toolbar to make
the options on the Map toolbar available when you work with spatial
data. |
OLAP Query |
Click OLAP toolbar to make
the options on the OLAP toolbar available when you work with OLAP
queries. |
Visual Reports toolbar |
Click Visual Reports toolbar to
make the options on the Visual Reports toolbar available when you
work with visual reports. |
Layout toolbar |
Click Layout toolbar to
make the options on the Layout toolbar available when you work with
visionary data. |
Formatting toolbar |
Click Formatting toolbar to
make the Formatting toolbar available when you are formatting columns
in the query results. |
Command toolbar |
Click Command toolbar to
make the Command toolbar available when you are using the command
line. |
Documents toolbar |
Click Documents toolbar to
make the Documents toolbar available where you can see all the documents
that you currently have open in the active window. |
Command bar
Use the command bar to run a procedure at a server directly
from any QMF window. You can type a command or select a command
from the Run command drop-down list. You can
select the associated server to run the command from the at server drop-down
list.
Control Bar
Select View--> Control Bar to
show or hide the following:
- Explorer Bar
- Status Bar
- Layout Designer
Explorer Bar
Select View--> Control Bars--> Explorer Bar to
display or hide the Explorer Bar. The Explorer Bar is a dockable
tools windows that opens in the left pane of the window but can
be moved.
The tools that use the Explorer Bar are the Database Explorer,
the Query Results Explorer and the Visual Reports Explorer as well
as the Object Analyzer.
Status bar
Select View--> Control Bars--> Status Bar to
display or hide the status bar at the bottom of every window.
The status bar displays information and messages and provides
status information for queries.
Layout Designer
Select View--> Control Bars--> Layout Designer to
display or hide the Layout Designer dockable window. The Layout
Designer window opens in the bottom of the screen but can be moved.
You use the Layout Designer when you work with query results.
Options [General tab]
Click View--> Options,
then click the General tab to set general
options for QMF for Windows, such as specifying which server definition
file (SDF) will be used.
Table 8. Fields on Options - General
Field |
Description |
Server definition file |
The server definition file (SDF) contains the
technical information QMF for Windows need to connect users to database
servers. Your QMF for Windows administrator creates, maintains and
distributes the SDF. The SDF that you are using is displayed in
this field.
If you have multiple SDFs, you can select another SDF by typing
the name of a SDF, or browsing with the browse button. |
Display recently used servers first |
Check this check box to display the most recently
used servers from the SDF first in the Database Explorer window. If
this check box is not checked, the servers are listed as they were
configured in the SDF. |
Filter |
Click this button to open the Filter Servers
window where you can select the database servers from the SDF that
will be included in the selection list. By default all database
servers that were configured in the SDF will be included in the selection
lists. |
Enable extensions for spatial data |
Check the Enable extensions for spatial data check
box to work with spatial data.
This check box controls whether information will be gathered for
the location, shape of, and relationships among business data and
geographic data, including map data, and stored in industry standard
files known as shapefiles (*.spm).
With shape files, spatial data can be interchanged with other applications
or databases that recognize this format. |
User Interface language |
Use this field to specify the language for the
QMF for Windows user interface. You can select the language from
a drop down list of supported languages. |
Options [Appearance tab]
Click View--> Options,
then click the Appearance tab to set appearance
options. The Appearance options specify the strings that will be
used for displaying and entering null and default values. You can
also specify the data orientation that will be used for query results
and reports, as well as whether coloring in text editors will be
enabled.
Table 9. Fields on Options - Appearance
Field |
Description |
Special values |
- Display null values as
- Type the string QMF for Windows uses to display null values
that are retrieved from the database server.
- Enter null values as
- Type the string to use when entering null values in query results
and in the Edit Table dialog box.
- Enter default values as
- Type the string to use when entering default values in query
results and in the Edit Table dialog box.
|
Data Orientation in query results and reports |
- Left-to-Right
Select this radio button to specify that the data orientation
in query results and reports will read from left to right.
- Right-to-Left
Select this radio button to specify that the data orientation
in query results and reports will read from right to left.
- Based on Operating System
Select this radio button to specify that the data orientation
in query results and reports will be based on what has been specified
for the operating system. If the operating system is bidi-enabled,
data will display in a right-to-left direction. If the operating
system is not bidi-enabled, data will display in a left-to-right
direction. |
Enable coloring in text editors |
Check this check box to enable coloring in text
editors. by checking this check box, the text that you type when
creating SQL queries will be color enhanced. For example, SQL verbs will
appear blue, while clauses are black. You can make changes to the
coloring specification using the Formatting bar. |
Options [Network tab]
Click View--> Options,
then click the Network tab to set network
options. The network options specify the connectivity-specific timeout
limits for all database servers that use DRDA over TCP/IP, CLI,
ODBC, or CPI-C connectivity. In addition, if you will access any
database server using DRDA over SNA connectivity, you must specify
the CPI-C services DLL that QMF for Windows will use in the Provider
DLL field
Table 10. Fields on Options - Network
Field |
Description |
TCP |
Use these fields to specify the timeouts for
all database servers to which QMF for Windows connects using TCP/IP.
- Warning
The number of seconds that can elapse before a user is notified
and given the opportunity to cancel a communication request that
has not completed.
- Cancel
The number of seconds that can elapse before QMF for Windows
automatically cancels a communication request that has not completed
and returns an error. |
CLI Timeouts |
Use these fields to specify the timeouts for
all database servers to which QMF for Windows connects using CLI
- Warning
The number of seconds that can elapse before a user is notified
and given the opportunity to cancel a communication request that
has not completed.
- Cancel
The number of seconds that can elapse before QMF for Windows
automatically cancels a communication request that has not completed
and returns an error. |
ODBC |
Use these fields to specify the timeouts for
all database servers to which QMF for Windows connects using ODBC.
- Warning
The number of seconds that can elapse before a user is notified
and given the opportunity to cancel a communication request that
has not completed.
- Cancel
The number of seconds that can elapse before QMF for Windows
automatically cancels a communication request that has not completed
and returns an error. |
CPI-C |
Use these fields to specify the timeouts for
all database servers to which QMF for Windows connects using TCP/IP.
- Warning
The number of seconds that can elapse before a user is notified
and given the opportunity to cancel a communication request that
has not completed.
- Cancel
The number of seconds that can elapse before QMF for Windows
automatically cancels a communication request that has not completed
and returns an error. |
CPI-C Provider DLL |
Use this field to specify the name of the Provider
DLL that QMF for Windows will use to access CPI-C services. You
can use the Browse icon to search for available Provider DLLs. For
information about what Provider DLLs you should use contact your
QMF for Windows Administrator. |
Options [LOBs]
Click View--> Options,
then click the LOBs tab to specify how to
handle retrieving and saving LOB data.
DB2 Universal Database has a LOB data type that is able to store
non-traditional data such as text files, multimedia files, images,
video, photograph, and sound files. A LOB is a database entry containing
a file that is stored on the database server. LOBs are large and
use a large amount of resources.
If the database being accessed contains tables with LOB fields,
the QMF for Windows Administrator can prevent access to these tables
using the resource limits for your user ID.
Table 11. Fields on Options - LOBs
Field |
Description |
Override LOB options if possible |
Check this check box to specify that you will
override the LOB options that have been specified by your QMF for Windows
Administrator for your resource limits group. Your QMF for Windows
Administrator must have given your resource limits group permission
to override the LOB options. If you do not have permission to override
LOB options, this check box is not available. |
Lob Retrieval Options |
You use this field to specify what large object
data (LOB) data you will be retrieving. There are four choices:
- Disable LOB columns
Select this radio button to disable LOB data retrieval. By selecting
this option, you will not be able to query any table that contains
LOB data.
- Disable LOB data retrieval
Select this radio button to disable LOB data retrieval but allow
access to the other columns in the tables that contain LOB data.
By selecting this option, you can query tables that contain LOB
data and get result data for all columns except those that contain
LOBs |
Table 12. Fields on Options - LOBs
Field |
Description |
|
- Retrieve LOB data on demand
Select this radio button to specify that you will query tables
that contain LOB data and you want your result data to be returned
for all columns including those that contain LOB objects. However,
you want to select the LOB objects that will be displayed in the
contents of the query results.
Unless otherwise specified, all users of QMF for Windows can
query tables that contain LOBs. To conserve resources, QMF for Windows
stores retrieved LOB data in a file. Pointers to the LOB data objects
are displayed in the query results. You click on the pointer to view
the LOB object.
- Retrieve LOB data automatically
Select this radio button to specify that you will query tables
that contain LOB data and you want your result data to be returned
for all columns, including those that contain LOB objects. All result
data is automatically displayed in the contents of the query results.
This option can potentially consume a large amount of resources
and time. |
LOB Saving Option |
You use this field to specify what large object
data (LOB) data you can save. There are two choices:
|
Maximum LOB column size (KB): |
Use this field to specify the maximum size of
a LOB column, in kilobytes, up to 2G (the maximum LOB size). The
default is 0, no maximum. If you query a table with LOB data that
is larger than the maximum, the LOB data will not be returned for
display. |
Options [Traces tab]
Click View--> Options,
then click the Traces tab to activate tracing.
You can select one or more components about which information will
be gathered during processing.
Note:
Use tracing only when you are diagnosing a problem,
because tracing can impact performance. Technical support will help
you set up the tracing logs and tracing methods.
More than one component can be selected for tracing.
Table 13. Fields on Options - Traces Window
Field |
Description |
Trace file |
The name of the file that will be used to store
the trace data that is gathered. Click the browse button to select
the trace file to use. |
DDM |
Check the DDM check box
to trace DDM operations, which is this is the most frequent type
of tracing used. DDM tracing can be used only for a DRDA connection
to DB2.
DDM tracing identifies the packages, the SQL sent and returned
from DB2, and displays query results in English and hex format. |
TCP |
Check the TCP check box
to apply tracing to operations executed under a TCP/IP connection
to DB2. |
CPI-C |
Check the CPI-C check
box to apply tracing to operations executed under a CPI-C connection
to DB2. DRDA over SNA uses CPI-C when making the connection to the
server. |
CLI |
Check the CLI check box
to apply tracing to operations executed under a CLI connection to
DB2. |
Embedded SQL |
Check the Embedded SQL check
box to apply tracing to embedded SQL operations. Embedded SQL are
SQL statements that are embedded within a host language program
and are prepared (via the BIND process) before the program is executed. |
SQLAM |
Check the SQLAM check box
(SQL Application Manager) to apply tracing to SQLAM operations.
SQLAM is a function that represents an application to the remote
relational database manager. The SQL application manager can be
present in both an application requester and an application server. |
REXX |
Check the REXX check box
(REstructured eXtended eXecutor) to apply tracing to IBM ObjectREXX
operations.
IBM Object REXX, an interpreted, structured, procedural script
programming language allows programs and algorithms to be written
in a clear, structured way. |
Internet Mail |
Check the Internet Mail check
box to apply tracing to Internet Mail operations. |
Messages |
Check the Messages check
box to apply tracing to the informational and error messages issued
during a process. |
Options [Web Update]
Click View--> Options,
then click the Web Update tab to check for
software application updates, such as modifications, on the QMF
Resource Center on the Web. You can download and apply and updates
from the Web page.
Table 14. Fields on Options - Web Update
Field |
Description |
Enable Web update |
Check the Enable Web update check
box to check for updates to QMF for Windows at the frequency specified
in the Check for update every __ days field.
If the Enable Web update feature is selected,
the procedure to check for Web updates will be performed on startup.
The following message displays if an update is found:
A new version of the product is available.
Do you want to see more details?
If you choose to see more details, your browser opens at the QMF
for Windows Resource Center. |
Check for update every days |
Type the number of days between checking for
updates to QMF for Windows in the Check for update every __ days field.
The default is one day from the last update. |
Display message if unable to check |
Check the Display message if unable to check check
box to receive a message if there are problems checking for an update,
such as Web communication, no Internet connection, or firewall prohibitions.
A message similar to the following is issued if there was a problem
checking for Web updates, such as from a firewall or communications
issues:
An unexpected error occurred while checking for updates. |
Options [Database Explorer]
Click View--> Options,
then click the Database Explorer tab to specify
the default options that will be used by the Database Explorer.
These options specify what branches to display in the tree, how
many objects will be included in the branches and whether objects
will be run or displayed when a user double clicks on them.
Table 15. Fields on Options - Database Explorer
Field |
Description |
Display |
Use this field to select the branches that are
included in the Database Explorer tree. Check one or more of the
following check boxes:
- Favorites
Check this check box to include a Favorites branch in the Database
Explorer tree. You can choose to include any QMF object in this
folder.
- Recently Used Servers
Check this check box to include a Recently Used Servers branch
in the Database Explorer tree. QMF for Windows will list and keep
track of the servers that you have used in the most recent order.
The number of servers listed is specified in the Recent List Entries
field. |
|
- Recently Used Objects
Check this check box to include a Recently Used Objects branch
in the Database Explorer tree. QMF for Windows will keep track of
and list the QMF for Windows objects that you have used in the most
recent order. The number of objects listed is specified in the Recent
List Entries field.
- All Servers
Check this check box to include an All Servers branch in the
Database Explorer tree. QMF for Windows will list all of the database
servers that have been configured in the SDF that you are using |
Recent List Entries |
Use these fields to specify the number of entries
that will be included in the Recently Used Servers and Recently
Used Objects branches of the Database Explorer tree.
- Servers
Use this field to specify the number of servers that will be included
in the Recently Used Servers branch of the Database Explorer tree.
You can include up to 8 servers.
- Objects
Use this field to specify the number of objects that will be included
in the Recently Used Objects branch of the Database Explorer tree.
You can include up to 8 objects. |
Default Action for Queries and Procedures |
Use these fields to select the action that QMF
for Windows will perform when you double-click on a object that
is included in the Database Explorer tree. Your choices are:
|
