Support for Native Select Syntax
Enterprise Access now supports native SELECT statements with the addition of the WITH NATIVE_SELECT clause:
SELECT * FROM tablename WITH NATIVE_SELECT;
This syntax enables native SELECT statement support in the way that DIRECT EXECUTE IMMEDIATE is used for non-SELECT statements. This clause is used to issue SQL statements to the host DBMS without gateway processing.
The WITH NATIVE_SELECT clause must be placed at the very end of the statement, after any other WITH clauses. Other restrictions are listed in "Select… With" clause restrictions in the Developing Portable Applications guide. Usage information is provided in "Examples—With NATIVE_SELECT" in the same guide.