DB2 graphic QMF Version 8

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 UDB for z/OS location, or if the current server is DB2 UDB for z/OS or a workstation database server
DSQEC_CC none 01 Provides the ability to suppress the carriage control characters in the report output format- values can be:
0
No carriage control character in column 1
1
Carriage control is in effect; the report will have a carriage control character in column 1
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 Database 2 Server for VM/ESA or VSE/ESA database
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.
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_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, 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- possible values are:
0
Do not share data with other users
1
Do share data with other users
DSQEC_TABS_LDB2 none 31 View for retrieving lists of tables and views at the current server, if it is DB2 UDB for z/OS, 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 Database 2 Server for VM/ESA or VSE/ESA database


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