This table shows supported OpenESQL Compiler Directive Options for SQL ODBC and SQL OCI.
| Directives | SQL ODBC Support | SQL OCI Support |
|---|---|---|
| ADOPICXISANSI | ||
| ALLOWNULLCHAR | X | X |
| ANSI92ENTRY | X | X |
| AUTOCOMMIT | X | X |
| AUTOFETCH | X | |
| BEHAVIOR (includes primitive directives) | X | X |
|
X | X |
|
X | |
|
X | X |
|
X | X |
|
X | |
|
X | |
|
X | |
|
X | |
| CHECK | X | X |
| CHECKDUPCURSOR | X | X |
| CHECKSINGLETON | X | X |
| CONCAT | X | X |
| CONNECTIONPOOL | X | |
| CURSORCASE | X | X |
| DATE | X | X |
| DATEDELIM | X | X |
| DB | X | X |
| DECDEL | X | X |
| DETECTDATE | X | X |
| ESQLVERSION | X | X |
| FIPSFLAG | X | X |
| GEN-CC2 | X | X |
| GEN-INIT-FLAG | X | X |
| GEN-CLASS-VAR | X | X |
| HSFTRACE | X | X |
| IGNORE-NESTED | X | X |
| INIT | X | X |
| ISOLATION | X | |
| JIT | X | X |
| MARS | X | |
| NIST | X | X |
| NOT | X | X |
| ODBCTRACE | X | X |
| ODBCV3 | X | X |
| OPTIMIZECURSORS | X | X |
| PARAMARRAY | X | |
| PASS | X | X |
| PRE | X | X |
| PREFETCH | X | |
| QUALFIX | X | X |
| RESULTARRAY | X | |
| STMTCACHE | X | X |
| TARGETDB | X | |
| TESTSQLSTATE | X | X |
| TIME | X | X |
| TIMEDELIM | X | X |
| THREAD | X | X |
| TRACELEVEL | X | X |
| TSTAMPSEP | X | X |
| USERCURLIB | X |