DSQ global variables that control how commands and procedures are executed

All of these global variables can be modified by the SET GLOBAL command.

Callable Interface Variable Name Command Interface Variable Name Length Description
DSQEC_ALIASES none 31 View for retrieving lists of table and view aliases when the user requests a list of tables from a DB2 for MVS/ESA location or if the current server is DB2 for MVS/ESA, or a workstation database server.
DSQEC_COLS_LDB2 none 31 View for retrieving column information for a table at the current location, if that location is DB2.
DSQEC_COLS_RDB2 none 31 View for retrieving column information for a table at a remote DB2 location (if it is not the current location).
DSQEC_COLS_SQL none 31 View for retrieving column information for a table in a DB2 for VM/ESA or VSE/ESA database.
DSQEC_DISABLEADM none 01 QMF Administrator Authority Suppression. When the value fo this global variable is changed, the effect is immediate. Possible values can be:
0
QMF Administrator authority is available (if the authid has QMF Administrator authority).
1
QMF Administrator authority is suppressed (regardless of the authority of the authid).
Note: The initial default value for this global variable may be overridden by the QMF installation exit.
DSQEC_FORM_LANG none 01 Establishes the default NLF language in a saved or exported form. Values can be:
0
The form will use the presiding NLF language.
1
The form will use English. This is the default.
DSQEC_ISOLATION none 01 Default Query isolation level. Values can be:
0
Isolation level UR, Uncommitted Read.
1
Isolation level CS, Cursor Stability. This is the default.
Attention: Setting the value to '0' can introduce non-existent data into a QMF report. Do not set the value to '0' if your QMF reports must be free of non-existent data.
Limited support
For QMF 7.2 the use of the value '0' is only effective with the following database servers (those supporting the SQL WITH clause):
  • DB2 for MVS V4 or higher
  • DB2 for VM/VSE V4 or higher
DSQEC_NLFCMD_LANG none 01 Set expected NLF language for commands. Values can be:
0
Commands must be in the presiding NLF language. This is the default.
1
Commands must be in English.
DSQEC_PRO_ENABLE none 01 This is used as a protection enable switch for all QMF objects. Values can be:
0
Disable the object protection panel. QMF will prompt the users if an object was modified in temporary storage. This is the default
1
Enable the object protection panel. QMF will prompt the users if an object was modified in temporary storage.
DSQEC_PRO_FORM none 01 This enables the display for FORM object protection. Values can be:
0
Disable the object protection panel. QMF will prompt the users if the FORM object was modified in temporary storage.
1
Enable the object protection panel. QMF will prompt the users if the FORM object was modified in temporary storage. This is the default.
DSQEC_PRO_PROC none 01 This allows PROC object protection. Values can be:
0
Disable the object protection panel. QMF will prompt the users if the PROC object was modified in temporary storage.
1
Enable the object protection panel. QMF will prompt the users if the PROC object was modified in temporary storage. This is the default.
DSQEC_PRO_PROF none 01 This allows PROFILE object protection. Values can be:
0
Disable the object protection panel. QMF will prompt the users if the PROFILE object was modified in temporary storage.
1
Enable the object protection panel. QMF will prompt the users if the PROFILE object was modified in temporary storage. This is the default.
DSQEC_PRO_QUERY none 01 This enables QUERY object protection. Values can be:
0
Disable the object protection panel. QMF will prompt the users if the QUERY object was modified in temporary storage.
1
Enable the object protection panel. QMF will prompt the users if the QUERY object was modified in temporary storage. This is the default.
DSQEC_RERUN_IPROC none 01 Rerun invocation procedure after the END command. Values can be:
0
Suppress rerun of invocation procedure after the END command.
1
Rerun the invocation procedure after the END command. This is the default.

If you start QMF with an invocation procedure, then set this variable to '0', QMF terminates instead of rerunning the procedure.

DSQEC_RESET_RPT none 31 Determines whether or not QMF prompts the user when an incomplete DATA object in temporary storage appears to be affecting performance. Possible values are:
0
Reset Report Prompt Panel is not displayed and QMF completes the running report. This is the default value.
1
Reset Report Prompt Panel is displayed. This panel prompts the user to complete or reset the currently running report before starting the new command.
2
Reset Report Prompt Panel is not displayed and QMF resets the currently running report.
DSQEC_SHARE none 31 Specifies the default value for the SHARE parameter. The possible values are:
0
Do not share data with other users.
1
Do share data with other users.
Note: the initial default value for this global variable may be overridden by the QMF installation exit.
DSQEC_TABS_LDB2 none 31 View for retrieving lists of tables and views at the current server, if it is DB2 for MVS/ESA, or a workstation database server.
DSQEC_TABS_RDB2 none 31 View for retrieving lists of tables and views at remote DB2 subsystems.
DSQEC_TABS_SQL none 31 View for retrieving lists of tables and views for a DB2 for VM/ESA or VSE/ESA database.
[ Previous Page | Next Page | Contents | Index ]