Was this helpful?
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.)
Last modified date: 01/30/2023