Enterprise Access and EDBC With Clause
The Enterprise Access and EDBC WITH clause enables DBMS‑specific options to be specified in an OpenSQL statement. EDBC and Enterprise Access servers process only the options directed at them, and ignore the rest. Valid options depend on the specific Enterprise Access or EDBC product, and DBMS. For information on valid WITH clause parameters, see your Enterprise Access or EDBC product guide. The DBMS, Enterprise Access, or EDBC is responsible for performing the specified action or translating the WITH clause to the syntax required by the underlying DBMS.
The following OpenSQL statements support the Enterprise Access and EDBC WITH clause:
• CONNECT
• CREATE INDEX
• CREATE TABLE
• CREATE VIEW
• DROP INDEX
• DROP TABLE
• DROP VIEW
• SELECT… WITH NATIVE_SELECT clause. (For more information, see the Enterprise Access Developing Portable Applications guide.)