x

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

Top of page

Example: 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

Top of page

Example: 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

Top of page

Example: 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

Top of page

Example: 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