Adapter Dialogue Manager Variables

In this section:

All 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.

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


Top of page

x
Dialogue Manager Variables for the Adapter for DB2

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, 910 for
                DB2 Version 9 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.

Top of page

x
Dialogue Manager Variables for the Adapter for Teradata

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

Top of page

x
Dialogue Manager Variables for the Adapter for IDMS/SQL

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

Top of page

x
Dialogue Manager Variables for the Adapter for Oracle

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


Information Builders