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 | 
| 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 |