This table shows all of the SQL compiler directive options and the DBMAN preprocessor options with which they are valid.
| Other Directives | DBMAN=ODBC | DBMAN=JDBC | |
|---|---|---|---|
| ADOPICXISANSI | |||
| ALLOWNULLCHAR | X | X | |
| ANSI92ENTRY | X | X | |
| AUTOCOMMIT | X | X | |
| AUTOFETCH | X | ||
| BEHAVIOR | X | X | |
| DEF_CURSOR | X | ||
| IC_FH_ISOLATION | X | ||
| PF_RO_CURSOR | X | ||
| PF_UPD_CURSOR | X | X (SQL Server only) | |
| RO_CURSOR | X | ||
| TRANSACTION | X | ||
| UPD_CONCURRENCY | X | ||
| UPD_CURSOR | X | ||
| CHECK | X | X | |
| CHECKDUPCURSOR | X | X | |
| CHECKSINGLETON | X | X | |
| CONCAT | X | X | |
| CONNECTIONPOOL | X | ||
| CTRACE | X | X | |
| CURSORCASE | X | ||
| DATE | X | X | |
| DATEDELIM | X | X | |
| DB | X | X | |
| DECDEL | X | ||
| DESCRIBEDTREC | X | X | |
| DESCRIBEDTCHAR | X | X | |
| DESCRIBEVARCHAR49 | X | X | |
| DESCRIBEVARCHARPICX | X | X | |
| DETECTDATE | X | ||
| ESQLVERSION | X | ||
| FIPSFLAG | X | ||
| GEN-CC2 | X | ||
| GEN-CLASS-VAR | X | ||
| GEN-INIT-FLAG | X | X | |
| HSFTRACE | X | ||
| IGNORE-NESTED | X | X | |
| IGNORESCHEMAERRORS | X | X | |
| INIT | X | X | |
| ISOLATION | X | ||
| JIT | X | X | |
| JNDI | X | ||
| JNDIENC | X | ||
| MARS | X | X | |
| NIST | X | X | |
| NOT | X | X | |
| ODBCTRACE | X | ||
| ODBCV3 | X | X | |
| PARAMARRAY | X | ||
| PASS | X | X | |
| PRE | X | ||
| PREFETCH | X | ||
| QUALFIX | X | X | |
| RESULTARRAY | X | ||
| SPDISPLAY | X | X | |
| SQLCLRTRANS | X | X | |
| STMTCACHE | X | X | |
| TARGETDB | X | X | |
| TESTSQLSTATE | X | ||
| TIME | X | X | |
| TIMEDELIM | X | X | |
| THREAD | X | ||
| TRACELEVEL | X | ||
| TSTAMPSEP | X | X | |
| USECURLIB | X | ||