Data Adapter Dialogue Manager Variables

All data adapter environmental settings are available for display and query as Dialogue Manager variables. The following sections list the variable names for each RDBMS, and the lines displaying their settings in the SQL ? query.

In this section: Dialogue Manager Variables for the DB2 Data Adapter Dialogue Manager Variables for the DB2 for VM Data Adapter Dialogue Manager Variables for the Teradata Data Adapter Dialogue Manager Variables for the IDMS/SQL Data Adapter Dialogue Manager Variables for the Oracle Data Adapter

Note: If the length of the current setting value is greater than 12, the Dialogue Manager variable makes only the first 12 characters available.

Dialogue Manager Variables for the DB2 Data Adapter

The following variables are available for DB2:

&SQLCAF       - (FOC1442) CALL ATTACH FACILITY IS
&SQLSSID      - (FOC1447) SSID FOR CALL ATTACH IS
&SQLPLANA     - (FOC1448) ACTIVE PLAN FOR CALL ATTACH IS
&SQLPLANU     - (FOC1459) USER SET PLAN FOR CALL ATTACH IS
&SQLPLANI     - (FOC1460) INSTALLATION DEFAULT PLAN IS
&SQLSTATIC    - (FOC1503) SQL STATIC OPTION IS
&SQLAUTOCLS   - (FOC1444) AUTOCLOSE OPTION IS
&SQLAUTODIS   - (FOC1496) AUTODISCONNECT OPTION IS
&SQLAUTOCOM   - (FOC1499) AUTOCOMMIT OPTION IS
&SQLDBSPACE   - (FOC1446) DEFAULT DBSPACE IS
&SQLID        - (FOC1449) CURRENT SQLID IS
&SQLISOLATION - (FOC1424) ISOLATION LEVEL FOR DB2 TABLE INTERFACE IS
&SQLWRITE     - (FOC1441) WRITE FUNCTIONALITY IS
&SQLOPT       - (FOC1445) OPTIMIZATION OPTION IS
&SQLITEOPT    - (FOC1763) IF-THEN-ELSE OPTIMIZATION IS
&SQLEMSG      - (FOC1484) SQL ERROR MESSAGE TYPE IS
&SQLEXPL      - (FOC1497) SQL EXPLAIN OPTION IS
&SQLQUERYNO   - (FOC1551) QUERY NUMBER TO BE USED FOR EXPLAIN
&SQLDEFDATE   - (FOC1552) INTERFACE DEFAULT DATE TYPE
&SQLOWNERID   - (FOC1520) SQL CURRENT OWNER ID IS
 
&SQLRELEASE   - Current release of DB2 in format Dxxx where
                xxx is release number (for example, 710 for
                DB2 Version 7 Release 1).
 
&SQLVVRRM     - Return from CONNECT in the form DSNvvrrM.
                vv is the Version of DB2, rr is the Release, M is the
                Modification level. For more information, consult IBM's
                DB2 SQL Reference.

Dialogue Manager Variables for the DB2 for VM Data Adapter

The following variables are available for DB2 for VM:

&SQLSTATIC   - (FOC1503) SQL STATIC OPTION IS
&SQLAUTODIS  - (FOC1496) AUTODISCONNECT OPTION IS
&SQLAUTOCOM  - (FOC1499) AUTOCOMMIT OPTION IS
&SQLDBSPACE  - (FOC1446) DEFAULT DBSPACE IS
&SQLWRITE    - (FOC1441) WRITE FUNCTIONALITY IS
&SQLOPT      - (FOC1445) OPTIMIZATION OPTION IS
&SQLITEOPT   - (FOC1763) IF-THEN-ELSE OPTIMIZATION IS
&SQLEMSG     - (FOC1484) SQL ERROR MESSAGE TYPE IS
&SQLEXPL     - (FOC1497) SQL EXPLAIN OPTION IS
&SQLQUERYNO  - (FOC1551) QUERY NUMBER TO BE USED FOR EXPLAIN
&SQLDEFDATE  - (FOC1552) INTERFACE DEFAULT DATE TYPE
&SQLVVRRM    - Return from CONNECT in the form ARIvvrrM.
               vv is the Version of DB2 for VM, rr is the Release, M is
               the Modification level. For more information, consult IBM's
               DB2 for VM SQL Reference.

Dialogue Manager Variables for the Teradata Data Adapter

The following variables are available for Teradata:

&DBCCON       - (FOC1463) DBC/1012 CONNECTION
&DBCPART      - (FOC1467) PARTITION
&DBCTDP       - (FOC1468) TERADATA DIRECTOR PROGRAM (TDP)
&DBCUSER      - (FOC1469) DBC/1012 USER ID
&DBCAUTOCLS   - (FOC1444) AUTOCLOSE OPTION IS
&DBCWRITE     - (FOC1441) WRITE FUNCTIONALITY IS
&DBCOPT       - (FOC1445) OPTIMIZATION OPTION IS
&DBCITEOPT    - (FOC1763) IF-THEN-ELSE OPTIMIZATION IS
&DBCEMSG      - (FOC1484) SQL ERROR MESSAGE TYPE IS
&DBCEXPL      - (FOC1497) SQL EXPLAIN OPTION IS
&DBCDEFDATE   - (FOC1552) INTERFACE DEFAULT DATE TYPE
&DBCOWNERID   - (FOC1520) DBC CURRENT OWNER ID IS

Dialogue Manager Variables for the IDMS/SQL Data Adapter

The following variables are available for IDMS/SQL:

&IDQDICTNAME  - (FOC1756) CURRENT IDMS DICTIONARY IS
&IDQCURSCHEMA - (FOC1757) CURRENT SCHEMA IS
&IDQISLEVEL   - (FOC1758) CURRENT ISOLATION LEVEL IS
&IDQAUTOCOM   - (FOC1499) AUTOCOMMIT OPTION IS
&IDQDBSPACE   - (FOC1446) DEFAULT DBSPACE IS
&IDQOPT       - (FOC1445) OPTIMIZATION OPTION IS
&IDQITEOPT    - (FOC1763) IF-THEN-ELSE OPTIMIZATION IS
&IDQDEFDATE   - (FOC1552) INTERFACE DEFAULT DATE TYPE

Dialogue Manager Variables for the Oracle Data Adapter

The following variables are available for Oracle:

&ORASERVER    - (FOC1656) DEFAULT SERVER NAME
&ORAUSER      - (FOC1502) USERID AND PASSWORD ARE
&ORAAUTODIS   - (FOC1496) AUTODISCONNECT OPTION IS
&ORAAUTOCOM   - (FOC1499) AUTOCOMMIT OPTION IS
&ORADBSPACE   - (FOC1446) DEFAULT DBSPACE IS
&ORAFETCHSIZE - (FOC1491) FETCH BUFFERING FACTOR
&ORAINSERTSIZ - (FOC1531) INSERT BUFFERING FACTOR
&ORASPMAXPRM  - (FOC1379) MAXIMUM STORED PROCEDURE PARAMETERS
&ORAWRITE     - (FOC1441) WRITE FUNCTIONALITY IS
&ORAOPT       - (FOC1445) OPTIMIZATION OPTION IS
&ORAITEOPT    - (FOC1763) IF-THEN-ELSE OPTIMIZATION IS
&ORAEMSG      - (FOC1484) SQL ERROR MESSAGE TYPE IS
&ORADEFDATE   - (FOC1552) INTERFACE DEFAULT DATE TYPE
&ORAOWNERID   - (FOC1520) ORACLE CURRENT OWNER ID IS
&ORADBSPACE   - (FOC1446) DEFAULT DBSPACE IS
 
&ORAMSGTXT - MESSAGE RETURNED BY AN ORACLE STORED PROCEDURE