This table shows all of the SQL compiler directive options and the DBMAN preprocessor options with which they are valid.
| Directive | DBMAN=ODBC | DBMAN=ADO | |
|---|---|---|---|
| ACCESS | X | X | |
| ADOPICXISANSI | X | ||
| ALLOWNULLCHAR | X | X | |
| ANSI92ENTRY | X | X | |
| ARRAYCHECK | 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 | X1 | |
| RO_CURSOR | X | ||
| TRANSACTION | X | ||
| UPD_CONCURRENCY | X | X | |
| UPD_CURSOR | X | ||
| BIND | X | X | |
| CHECK | X | X | |
| CHECKDUPCURSOR | X | X | |
| CHECKSINGLETON | X | X | |
| CLOSE_ON_COMMIT | X | X | |
| CLOSE_ON_ROLLBACK | X | X | |
| CONCAT | X | ||
| CONNECTIONPOOL | X | ||
| CTRACE | X | X | |
| CURSORCASE | X | ||
| DATE | X | X | |
| DATEDELIM | X | X | |
| DB | X | X | |
| DECDEL | X | ||
| DESCRIBEDTCHAR | X | X | |
| DESCRIBEDTREC | X | X | |
| DESCRIBEVARCHAR49 | X | X | |
| DESCRIBEVARCHARPICX | X | X | |
| DETECTDATE | X | X2 | |
| ESQLVERSION | X | ||
| FIPSFLAG | X | ||
| GEN-CC2 | X | ||
| GEN-CLASS-VAR | X | X | |
| GEN-HV-FROM-GROUP | X | X | |
| GEN-INIT-FLAG | X | X | |
| GEN-SQLCA | X | X | |
| HSFTRACE | X | X | |
| IGNORE-NESTED | X | X | |
| IGNORESCHEMAERRORS | X | X | |
| INIT | X | X | |
| ISOLATION | X | ||
| JIT | X | X | |
| MARS | X | X | |
| NESTEDCLRDEBUG | X | ||
| NIST | X | X | |
| NOT | X | X | |
| ODBCTRACE | X | ||
| ODBCV3 | X | X | |
| OPTIMIZECURSORS | X | X | |
| OPTIMIZESPCURSORS | X | ||
| OPTION | X | X | |
| OPTPER | X | ||
| PARAMARRAY | X | ||
| PASS | X | X | |
| PICXBINDING | X | X | |
| PRE | X | ||
| PREFETCH | X | ||
| PROCOB | X | ||
| QUALFIX | X | X | |
| RESULTARRAY | X | ||
| SAVE-RETURN-CODE | X | X | |
| SPCOMMITONRETURN | X | ||
| SPDISPLAY | X | X | |
| STMTCACHE | X | X | |
| TARGETDB | X | X | |
| TESTSQLSTATE | X | ||
| THREAD | X | ||
| TIME | X | X | |
| TIMEDELIM | X | X | |
| TRACELEVEL | X | ||
| TSTAMPSEP | X | X | |
| UNSAFE_NULL | X | ||
| USECURLIB | X | ||
| USER-SQLDA | X | ||
| XAID | X | ||
|
1 SQL Server only 2 SQL Server 2012 and later only |
|||