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:
|
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:
|
DSQEC_ISOLATION | none | 01 | Default Query isolation level- values
can be:
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:
|
DSQEC_RERUN_IPROC | none | 01 | Rerun invocation procedure after
the END command- values can be:
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:
|
DSQEC_SHARE | none | 31 | Specifies the default value for
the SHARE parameter- possible values are:
|
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 |