DB2 graphic QMF Version 8

Windows environment variables

Global variable names prefixed with DSQQW are specific to the QMF for Windows connections. You can also modify these variables with the SET GLOBAL command.

Table 74. Windows Environment Global Variables
Global variable Length Description
DSQQW_AUTOMATION 1 Indicates whether the current instance of QMF for Windows was started to service OLE automation requests (value is 1) or to service the user interface (value is 0).
DSQQW_CONNECTIONS 1 Use server connections while running a procedure. This setting controls the number of server connections for procedures.
  • 0 = minimize the number of connections. This is the default.

    Specifying a value of 0 can force QMF for Windows to reset or complete a data object before continuing the execution of a procedure.

    If set to 0, you specify a linear connection, which means that the first query must complete before the next is run. These queries are run in a series.

  • 1 = all: a new connection for each RUN QUERY command

    If set to 1, subsequent connections are opened so the queries are run in parallel (at the same time).

Note:
This global variable is designed to be used with DSQQW_FST_SV_DATA (by which the query will be PREPARED only on RUN QUERY.
DSQQW_DQ " Double-quote character
DSQQW_EXP_DT_FRMT 1 Format for EXPORT DATA. Value can be:
  • 0 = text. This is the default.
  • 2 = html
  • 3 = csv (comma-separated value)
  • 4 = ixf

For the EXPORT command, you can export the report to a file name with a file type of .qmf, .html or .txt.

Note:
In a procedure (with a .txt file type), if no options are specified as delimiters, the default is spaces.
DSQQW_EXP_OUT_MDE 1 IXF mode for procedures. Value can be:
  • 0 = System/370 character mode IXF. This is the default.
  • 1 = PC/IXF
DSQQW_FST_SV_DATA 1 Use 'Fast Save' mode for SAVE DATA. Value can be:
  • 0 = do not use fast mode. This is the default.
  • 1 = use fast mode
DSQQW_HTML_REFTXT 55 Text for &REF form variable. The default is 'Back To'.
DSQQW_PROC_OUTPUT Report Center will pass the path name and file name to a procedure that uses &DSQQW_PROC_OUTPUT.

EXPORT REPORT TO &DSQQW_PROC_OUTPUT

Alternatively:

EXPORT DATA TO &DSQQW_PROC_OUTPUT

DSQQW_QUERY_LANG 1 Subtype of query created by DISPLAY QUERY when no query object exists. Value can be:
  • 0 = SQL. This is the default.
  • 1 = prompted
DSQQW_QUERY_PREP Prepare the query on a RUN command instead of running. This option invokes the PREPARE SQL command.

DB2 will check the query syntax and the existence of every object associated with the query. Internal calculations will be performed, but no data will be sent to the client.

This option can be used to validate queries with complicated calculations or ones that will return significant data. Value can be:

  • 0 = No
  • 1 = Yes
DSQQW_RPT_COPIES 10 Number of copies for PRINT REPORT. The default is 1.
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used. If it is set to 2, the global variable settings are used.
DSQQW_RPT_FONT 55 Font for PRINT REPORT. The default is 'Courier New'.
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used. If it is set to 2, the global variable settings are used.
DSQQW_RPT_FONT_BD 1 Bold attribute for PRINT REPORT. The default is 0.
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used; if it is set to 2, the global variable settings are used.
DSQQW_RPT_FONT_IT 1 Italic attribute for PRINT REPORT. The default is 0.
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used; if it is set to 2, the global variable settings are used.
DSQQW_RPT_FONT_SZ 2 Font size for PRINT REPORT. The default is 10.
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used; if it is set to 2, the global variable settings are used.
DSQQW_RPT_LEN_TYP 1 Type of page length for PRINT REPORT. The value can be:
  • 0 = fit the length of the printed page. This is the default.
  • 1 = specify an explicit number of lines
  • 2 = specify a continuous report with no page breaks
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used; if it is set to 2, the global variable settings are used.
DSQQW_RPT_NUM_CHR 10 Number of characters across a printed page for PRINT REPORT. This has an effect only when DSQQW_RPT_WID_TYP is 1. The default value is 80.
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used; if it is set to 2, the global variable settings are used.
DSQQW_RPT_NUM_LNS 10 Number of lines down a page for PRINT REPORT. This has an effect only when DSQQW_RPT_LEN_TYP is 1. The default value is 60.
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used; if it is set to 2, the global variable settings are used.
DSQQW_RPT_ORIENT 1 Page orientation for PRINT REPORT. The value can be:
  • 0 = portrait. This is the default.
  • 1 = landscape
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used; if it is set to 2, the global variable settings are used.
DSQQW_RPT_USE_PS 1 Set of page formatting options (page length, page length) for PRINT REPORT. The value can be:
  • 0 = use the values specified on the PRINT REPORT command or in global variables
  • 1 = use the values specified in the form document's page setup. This is the default.
Note:
If this value is set to 1, the Page Setup options are used; if it is set to 2, the global variable settings are used.
DSQQW_RPT_WID_TYP 1 Type of page width for PRINT REPORT. The value can be:
  • 0 = fit the width in the printed page. This is the default.
  • 1 = specify an explicit number of characters.
Note:
If this value is set to 1, the Page Setup options are used; if it is set to 2, the global variable settings are used.
DSQQW_SHOW_QUERY 1 View of a query for SHOW QUERY. The value can be:
  • 0 = SQL or prompted view. This is the default.
  • 1 = results view
DSQQW_STRIP_SPACE 1 Remove trailing spaces from objects retrieved from server. The value can be:
  • 0 = retain trailing spaces
  • 1 = remove trailing spaces. This is the default.
DSQQW_SV_DATA_C_S 10 Rows to insert before commit for SAVE DATA. Value can be:
  • 0 = all rows. This is the default.
  • n = where n equals an explicit number of rows
DSQQW_UEDIT_DLL 55 DLL implementing user edit routines. The default value is rsuedit.dll
DSQQW_PROC_WNDWS Procedure results options. The values are:
  • 0 = leave the most recent objects open at the end of the procedure

    For example, leave the most recent query and form open at the end of the procedure, but not the most recent procedure.

  • 1 = leave all objects open at the end of the procedure


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