SQLMode allows for using the ODBC driver in another SQLMODE. The ODBC driver then does not only understand the ODBC- and ADABAS-specific syntax but also ORACLE SQL or DB2. This is especially useful if the available code is adapted to another ODBC driver. The DBMS supports the data types and SQL syntax of the corresponding system. In SQLMode ORACLE, the ORACLE system catalog is reproduced.
Syntax:
SQLMode = ADABAS | (Default)
DB2 |
ANSI |
ORACLE
Note:
The syntax valid for the corresponding SQLMODE is described in the manuals of the manufacturers. For the ADABAS restrictions, see the corresponding sections in the ADABAS Reference manual.