Querying Adapter Parameter Settings

The SQL query command displays defaults and current settings for each adapter.

Query Data Adapter Parameter Settings

{ENGINE|SQL} [sqlengine] ?

where:

sqlengine

Indicates the target RDBMS. Valid values are DB2, SQLDBC, SQLIDMS, or SQLORA. Omit if you previously issued the SET SQLENGINE command.

Querying Adapter for DB2 Settings

The following is an example for DB2: 

> sql db2 ?
(FOC1440) CURRENT SQL INTERFACE SETTINGS ARE :                  
(FOC1442) CALL ATTACH FACILITY IS             -  : ON           
(FOC1447) SSID FOR CALL ATTACH IS             -  : DBAA         
(FOC1448) ACTIVE PLAN FOR CALL ATTACH IS      -  : USER1CAF      
(FOC1459) USER SET PLAN FOR CALL ATTACH IS    -  : USER1CAF      
(FOC1460) INSTALLATION DEFAULT PLAN     IS    -  : M727703B     
(FOC1503) SQL STATIC OPTION IS                -  : OFF          
(FOC1444) AUTOCLOSE OPTION IS                 -  : ON FIN       
(FOC1496) AUTODISCONNECT OPTION IS            -  : ON FIN       
(FOC1499) AUTOCOMMIT OPTION IS                -  : ON COMMAND   
(FOC1449) CURRENT SQLID IS                    -  : SYSTEM DEFAUL
(FOC1424) ISOLATION LEVEL FOR DB2 TABLE INTERFACE IS  :         
(FOC1491) FETCH BUFFERING FACTOR              -  : 100          
(FOC1441) WRITE FUNCTIONALITY IS              -  : ON           
(FOC1445) OPTIMIZATION OPTION IS              -  : ON           
(FOC1763) IF-THEN-ELSE OPTIMIZATION IS        - : ON            
(FOC1484) SQL ERROR MESSAGE TYPE IS           -  : DBMS         
(FOC1497) SQL EXPLAIN OPTION IS               -  : OFF          
(FOC1552) INTERFACE DEFAULT DATE TYPE         -  : NEW          
(FOC1446) DEFAULT DBSPACE IS                  -  : PUBLIC.SPACE0

Querying Adapter for Teradata Settings

The following is an example for Teradata:

> sql sqldbc ?
(FOC1461) CURRENT DBC/SQL SETTINGS ARE:
(FOC1463) DBC/1012 CONNECTION                 -  : OFF
(FOC1467) PARTITION                           -  : DBC/SQL
(FOC1468) TERADATA DIRECTOR PROGRAM (TDP)     -  : 0
(FOC1469) DBC/1012 USER ID                    -  : DBC
(FOC1444) AUTOCLOSE OPTION IS                 -  : ON COMMAND
(FOC1465) DBC COLNAME OPTION IS               -  : TITLE
(FOC1441) WRITE FUNCTIONALITY IS              -  : ON
(FOC1445) OPTIMIZATION OPTION IS              -  : ON
(FOC1763) IF-THEN-ELSE OPTIMIZATION IS        -  : OFF
(FOC1497) SQL EXPLAIN OPTION IS               -  : OFF
(FOC1552) INTERFACE DEFAULT DATE TYPE          -  : NEW

Querying Adapter for IDMS/SQL Settings

The following is an example for IDMS/SQL:

> sql sqlidms ?
(FOC1756) CURRENT IDMS DICTIONARY IS      -  : SYSTEM DEFAULT
(FOC1757) CURRENT SCHEMA IS               -  : SYSTEM DEFAULT
(FOC1758) CURRENT ISOLATION LEVEL IS       -  : READ WRITE CURSOR 
STABILITY
(FOC1499) AUTOCOMMIT OPTION IS            -  : ON COMMAND
(FOC1445) OPTIMIZATION OPTION IS          -  : ON
(FOC1763) IF-THEN-ELSE OPTIMIZATION IS    -  : OFF
(FOC1552) INTERFACE DEFAULT DATE TYPE     -  : NEW
(FOC1446) DEFAULT DBSPACE IS

Querying Adapter for Oracle Settings

The following is an example for Oracle:

> sql sqlora ?
(FOC1450) CURRENT ORACLE INTERFACE SETTINGS ARE  :
(FOC1656) DEFAULT SERVER NAME                 -  : <local>
(FOC1502) USERID AND PASSWORD ARE             -  : SCOTT
(FOC1496) AUTODISCONNECT OPTION IS            -  : ON FIN
(FOC1499) AUTOCOMMIT OPTION IS                -  : ON COMMAND
(FOC1491) FETCH BUFFERING FACTOR              -  : 20
(FOC1531) INSERT BUFFERING FACTOR             -  : 1
(FOC1379) MAXIMUM STORED PROCEDURE PARAMETERS -  : 256
(FOC1652) CHARACTER TYPE FOR INSERT OR UPDATE -  : VAR
(FOC1653) CONVERSION STYLE FOR ORACLE NUMBERS -  : COMPAT
(FOC1654) ORACLE HOME                         -  : Not set
(FOC1655) ORACLE SID                          -  : Not set
(FOC1441) WRITE FUNCTIONALITY IS              -  : ON
(FOC1445) OPTIMIZATION OPTION IS              -  : ON
(FOC1763) IF-THEN-ELSE OPTIMIZATION IS        -  : OFF
(FOC1552) INTERFACE DEFAULT DATE TYPE         -  : NEW
(FOC1446) DEFAULT DBSPACE IS