Direct SQL Passthru is a facility for passing native SQL commands directly to the RDBMS without intervention by FOCUS, and for issuing environmental commands that display or change data adapter default settings. For a detailed discussion of the Direct SQL Passthru facility, consult Direct SQL Passthru. |
In this section: Data Adapter Environmental Commands Example: |
The data adapter provides environmental commands that display or change data adapter default settings for the duration of the FOCUS session. You can issue these commands from the FOCUS command line or include them in a FOCEXEC. To display current data adapter settings during a FOCUS session, issue the following command:
SQL sqlengine ?
where:
To display the current data adapter settings for a DB2 session within FOCUS, issue the following data adapter query command:
> 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 :
(FOC1576) INSTHOME : Not set
(FOC1577) DB2INSTANCE : Not set
(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
See Environmental Commands for an explanation of the data adapter environmental commands.
| Information Builders |