Global variables for state information not related to the profile

DSQAO global variables contain status information or settings of parameters or flags. None of these global variables can be modified by the SET GLOBAL command.

Table 1. Global variables for state information not related to the profile
Callable interface variable name Command interface variable name Length Description
DSQAO_APPL_TRACE DSQATRAC 01
0
for level A0
1
for level A1
2
for level A2
DSQAO_ATTENTION DSQCATTN 01 User attention flag.
DSQAO_BATCH DSQABATC 01 Batch or interactive mode; values can be:
1
for an interactive session
2
for a batch-mode session
DSQAO_CONNECT_ID DSQAAUTH 128 The user ID used to connect to the database and under which work is done.
The value of this variable changes when you issue the following command or statement:
  • Issue a QMF CONNECT command to reconnect to the database under a different authorization ID
  • Issue a SET CURRENT SQLID statement on a Db2 for z/OS® database.
DSQAO_CONNECT_LOC None 18 The location name of the database to which you are currently connected; the name is 16 characters (padded to the right with blanks, if necessary).
DSQAO_CURSOR_OPEN DSQACRSR 01` Database cursor status; values can be:
1
if the cursor is open
2
if the cursor is closed
DSQAO_DATE_FORMAT None 05 Contains the value that is specified in SYSIBM.DATE_FORMAT.

Values can be ISO, USA, EUR, JIS, or LOCAL.
DSQAO_DB_MANAGER DSQADBMG 01 Database manager, indicated by one of the following values:
1
DB2® for VSE and VM
2
Db2® for z/OS
3
Db2 for Linux®, UNIX, and Windows
4
DB2 for iSeries
DSQAO_DBCS DSQADBCS 01 DBCS support status; values can be:
1
for DBCS support
2
for no DBCS support
DSQAO_DSQSBSTG None 10 Contains the value specified by the DSQSBSTG parameter or the default if the parameter was not specified.
DSQAO_DSQSFISO None 01 Contains the value that is specified by the DSQSFISO parameter or the default if the parameter was not specified.

The following values are used:

0
QMF is not precompiled with DATE(ISO) and TIME(ISO).
1
QMF is precompiled with DATE(ISO) and TIME(ISO). This is the default.
DSQAO_DSQSMRFI None 01 This field reflects the value that was specified for the DSQSMRFI program parameter when QMF was started.
0
NO was specified for the DSQSMRFI program parameter, meaning that Db2 single-row fetch and insert is used.
1
YES was specified for the DSQSMRFI program parameter, meaning that Db2 multirow fetch and insert is used. Multirow fetch uses a rowset cursor.
DSQAO_DSQSMTHD None 01

Contains the value specified by the DSQSMTHD program parameter or the default if the parameter was not specified.

The following values are used:

0
NO was specified; QMF runs with one thread. This is the default.
1
YES was specified; QMF will run with a second thread that will be used for commands (RUN QUERY, DISPLAY TABLE) and subsequent scrolling (BOTTOM, TOP, FORWARD, BACKWARD, RIGHT and LEFT) of reports with open cursors.
DSQAO_DSQSPILL None 01 Contains the value specified by the DSQSPILL parameter or the default if the parameter was not specified.
The following values are used:
0
for not using spill storage. This value corresponds with a DSQSPILL parameter value of NO.
1
for using spill storage. This value corresponds with a DSQSPILL parameter value of YES.
DSQAO_DSQSPTYP None 5 Contains the value specified by the DSQSPTYP parameter or the default if the parameter was not specified.
The following values are used:
FILE
for spilling data to a file.
64BIT
for spilling data to extended virtual storage.
DSQAO_DSQSRSTG None 8 Contains the value specified by the DSQSRSTG parameter or the default if the parameter was not specified.
DSQAO_FORM_PANEL DSQASUBP 02 Current form panel; values can be:
1
for FORM.MAIN
2
for FORM.COLUMNS
3
for FORM.PAGE
4
for FORM.FINAL
5
for FORM.BREAK1
6
for FORM.BREAK2
7
for FORM.BREAK3
8
for FORM.BREAK4
9
for FORM.BREAK5
10
for FORM.BREAK6
11
for FORM.OPTIONS
12
for FORM.CALC
13
for FORM.DETAIL
14
for FORM.CONDITIONS
A blank value means that the form does not exist in QMF temporary storage.
DSQAO_INTERACT DSQAIACT 01 Setting of the interact flag; values can be:
0
for no interactive execution
1
when interactive execution is allowed
DSQAO_LOCAL_DB2 None 18

The location name of the local Db2 for z/OS database.

This value is the location name for the subsystem named in the variable DSQAO_SUBSYS_ID. In a remote unit of work environment, DSQ_LOCAL_DB2 is the name of the application requester. The name is 16 characters (padded to the right with blanks, if necessary).
DSQAO_LOCATION DSQAITLO 18 Location name of the current object, if any.

This value is applicable only if a three-part name was used. The name is 16 characters (padded to the right with blanks, if necessary).
DSQAO_NLF_LANG DSQALANG 01 National language of user; for the English language environment, this value is ‘E’.
DSQAO_NUM_FETCHED DSQAROWS 16 Fetched data rows; contains '0' when the DATA object is empty.
DSQAO_OBJ_NAME DSQAITMN 128 The name of the table (contained in a report), query, procedure, or form shown on the currently displayed panel.

If the current panel does not display an object, or if the displayed object has no name, this variable contains blanks.
DSQAO_OBJ_OWNER DSQAITMO 128 The owner of the table (contained in a report), query, procedure, or form shown on the currently displayed panel.

If the current panel does not display an object, or if the displayed object has no owner, this variable contains blanks
DSQAO_OTC_LICENSE None 01

QMF product identifier

0
Indicates that no product identifier was found.
1
Indicates that the product identifier for DB2 for QMF for z/OS standalone product, 5687-QMF, was found.
2
Indicates that the product identifier for DB2 QMF Classic Edition (5698-DB2) was found.
3
Indicates that the product identifier for DB2 QMF Enterprise Edition (5698-DB2) was found.
DSQAO_PANEL_TYPE DSQAITEM 01 Type of current panel; values can be:
1
for HOME
2
for QUERY
3
for REPORT
4
for FORM
5
for PROC
6
for PROFILE
7
for CHART
8
for LIST
9
for Table Editor
A
for GLOBALS
DSQAO_QMF_RELEASE DSQAREVN 02

Numeric release number of QMF, which is displayed in header records for exported forms, reports, and prompted queries. For QMF Version 13 Release 1, this value is '20'.
DSQAO_QMF_VER_RLS DSQAQMF 10

Version and release of QMF. For QMF Version 13 Release 1, this value is 'QMFV13R1.0'.
DSQAO_QMFADM None 01 QMF administrator authority:
0
Current authorization ID does not have QMF administrator authority.
1
Current authorization ID has administrator authority.
DSQAO_QRY_SUBTYPE DSQASUBI 01 Query subtype; values can be:
1
for a subtype of SQL
2
for a subtype of QBE
3
for a subtype of PROMPTED

Blank means that the current panel is not QUERY.
DSQAO_QUERY_MODEL DSQAMODL 01

Model for data access.

Value is always '1' for relational.
DSQAO_ROW_LENGTH DSQAROWW 05 Contains a value indicating the length in bytes of each data row returned from the last processed query (if the report is still in storage). If the report is no longer in storage, the value is reset to 0 (zero).

Values can be:

0
No report currently in storage.
n
Indicates the number of bytes in the row.
DSQAO_SAME_CMD DSQACMDM 01 Values can be:
0
if the two commands are not the same
1
if the two commands are the same
DSQAO_STO_PROC_INT None 01 Shows whether QMF for TSO was started as a Db2 for z/OS stored procedure. Possible values are:
0
QMF was not started as a stored procedure.
1
QMF was started as a stored procedure.
DSQAO_SUBSYS_ID None 04 If QMF is running in TSO, this value is the ID of the local Db2 subsystem to which QMF is attached.

If you specify a value for the DSQSSUBS program parameter in CICS®, this global variable contains that value. The parameter is tolerated and the value is not processed. The value is placed in the global variable field and nothing is done with it. This logic permits the same program to be used in multiple environments.
DSQAO_SYSTEM_ID DSQASYST 01 Current operating system; values can be:
2
TSO under z/OS
3
TSO or native z/OS
5
CICS
DSQAO_TERMINATE DSQCSESC 01 QMF termination flag; values can be:
0
if the session was not marked for termination
1
if the session was marked for termination
DSQAO_TIME_FORMAT None 05 Contains the value that is specified in SYSIBM.TIME_FORMAT.

Values can be ISO, USA, EUR, JIS, or LOCAL.
DSQAO_VARIATION DSQAVARN 02 Form panel variation number; blank means FORM.DETAIL is not the current panel.