In this section: |
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 adapter default settings. For a detailed discussion of the Direct SQL Passthru facility, consult Direct SQL Passthru.
The adapter provides environmental commands that display or change 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 adapter settings during a FOCUS session, issue the following command:
{ENGINE|SQL} sqlengine ?where:
Indicates the target RDBMS. Valid values are DB2, SQLDS, SQLDBC, SQLIDMS, or SQLORA.
To display the current adapter settings for a DB2 session within FOCUS, issue the following adapter query command:
> engine 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 - : USERCAF (FOC1459) USER SET PLAN FOR CALL ATTACH IS - : USERCAF (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 DEFAULT (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 - : DBUSER01.FOCUS
See Adapter Commands for an explanation of the adapter environmental commands.
| Information Builders |