DB2 graphic QMF Version 8

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:

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.
  1. Select Query--> Set Row Limit.

    The Set Row Limit dialog box opens.

  2. 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.

  3. 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

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:
  • Disable LOB data

    Select this radio button to disable saving LOB data on the database server.

  • Enable LOB data

    Select this radio button to allow saving LOB data on the database server.

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:
  • Run object

    Select this radio button to run the object that is selected in the Database Explorer tree.

  • Display object

    Select this radio button to display the object that is selected in the Database Explorer tree.


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