DSQAO global variables

Global variables whose names begin with DSQAO provide information about the current state of the query session.

The following DSQAO global variables are available:
Name Length Description
DSQAO_BATCH 1 Batch or interactive mode. Value can be one (1) for an interactive session or two (2) for a batch session. See the BATCH command line parameter.
DSQAO_CONNECT_ID 8 The user ID that is used to connect to the current database.
DSQAO_CURSOR_OPEN 1 The status of the current query object's database cursor. Value can be one (1) if the cursor is open or two (2) if the cursor is closed.
DSQAO_DBCS 1 DBCS support status. Value can be one (1) if DBCS support is present or two (2) if DBCS support is not present.

DSQAO_HOME_WORKSPACE

128
The current repository user's home workspace key, if the workspace exists. Valid values are:
  • rsbi:/.workspaces/<user name>

    This is the value if the user connected to a secured repository connection and if the rsbi:/.workspaces/<user name> object is viewable by the current user in the repository. <user name> is the login name of the repository user.

  • rsbi:/.workspaces

    This is the value if the user connected to a repository connection without security, or the rsbi:/.workspaces/<user name> is not viewable by the user, or it does not exist.

  • blank

    This is value if the previous situations do not exist. For example, if the user is not connected to any repository connection.

Note: Workspace operations such as creating, deleting, and renaming performed by the current user affect the Global Variable value. Additionally, such operations performed by other users might also affect the value.
DSQAO_NLF_LANG 1 National language of session. Value is "E" for the English language.
DSQAO_NUM_FETCHED 0 The number of rows fetched by the current query object.
DSQAO_OBJ_NAME 18 The name of the current query, form, or procedure object. If there is no current object, the value is blank.
DSQAO_OBJ_OWNER 8 The owner of the current query, form, or procedure object. If there is no current object, the value is blank.
DSQAO_REP_USER 8 The user name that is used to connect to the current repository.
DSQAO_RSBI_RELEASE 2 Numeric release number of the application.
DSQAO_RSBI_VER_RLS 10 External version and release number for the application.
DSQAO_QUERY_MODEL 1 Model of the current query object. Value can be one (1) for relational.
DSQAO_QRY_SUBTYPE 1 Subtype of the current query object. Value can be one (1) for SQL queries or three (3) for queries in a prompted view.
DSQAO_SYSTEM_ID 1 Current operating system. Values can be one of the following:
  • 8 - Windows NT and above
  • 9 - Linux®
  • 10 - HP-UX
  • 11 - AIX®
  • 12 - Solaris
  • 13 - iSeries
  • 14 - z/OS®