Querying Data Adapter Parameter Settings

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

How to: Query Data Adapter Parameter Settings Example: Querying DB2 Data Adapter Settings Querying DB2 for VM Data Adapter Settings Querying Teradata Data Adapter Settings Querying IDMS/SQL Data Adapter Settings Querying Oracle Data Adapter Settings

Syntax: How to Query Data Adapter Parameter Settings

SQL [sqlengine] ?

where:

sqlengine

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

Example: Querying DB2 Data Adapter 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             -  : DSNA
(FOC1448) ACTIVE PLAN FOR CALL ATTACH IS      -  :
(FOC1459) USER SET PLAN FOR CALL ATTACH IS    -  :
(FOC1460) INSTALLATION DEFAULT PLAN     IS    -  : P7029910
(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 DEFAULT
(FOC1424) ISOLATION LEVEL FOR DB2 TABLE INTERFACE IS  :
(FOC1441) WRITE FUNCTIONALITY IS              -  : ON
(FOC1445) OPTIMIZATION OPTION IS              -  : ON
(FOC1420) OPTIMIZATION OF ALL=ON AS LEFT JOIN -  : OFF
(FOC1763) IF-THEN-ELSE OPTIMIZATION IS        -  : OFF
(FOC1484) SQL ERROR MESSAGE TYPE IS           -  : DBMS
(FOC1497) SQL EXPLAIN OPTION IS               -  : OFF
(FOC1552) INTERFACE DEFAULT DATE TYPE         -  : NEW
(FOC1446) DEFAULT DBSPACE IS
 
(FOC1453) DEFAULT INDEX SPACE PARAMETERS      -  : USING STOGROUP PMSSTGRP

Example: Querying DB2 for VM Data Adapter Settings

The following is an example for DB2 for VM:

> sql sqlds ?
(FOC1440) CURRENT SQL INTERFACE SETTINGS ARE :
(FOC1442) CALL ATTACH FACILITY IS             -  : OFF
(FOC1503) SQL STATIC OPTION IS                -  : OFF
(FOC1496) AUTODISCONNECT OPTION IS            -  : ON FIN
(FOC1499) AUTOCOMMIT OPTION IS                -  : ON COMMAND
(FOC1441) WRITE FUNCTIONALITY IS              -  : ON
(FOC1445) OPTIMIZATION OPTION IS              -  : ON
(FOC1420) OPTIMIZATION OF ALL=ON AS LEFT JOIN -  : OFF
(FOC1763) IF-THEN-ELSE OPTIMIZATION IS        - : OFF
(FOC1497) SQL EXPLAIN OPTION IS               - : OFF
(FOC1552) INTERFACE DEFAULT DATE TYPE         - : NEW
(FOC1446) DEFAULT DBSPACE IS                   - :

Example: Querying Teradata Data Adapter 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

Example: Querying IDMS/SQL Data Adapter 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

Example: Querying Oracle Data Adapter 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