次の表は、すべての SQL コンパイラ指令オプションとそれらが有効な DBMAN プリプロセッサ・オプションを示しています。
| 他の指令 | 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 サーバのみ) | |
| 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 | ||
| DB | X | X | |
| DECDEL | X | ||
| DETECTDATE | X | ||
| ESQLVERSION | X | ||
| FIPSFLAG | X | ||
| GEN-INIT-FLAG | X | X | |
| HSFTRACE | X | ||
| IGNORE-NESTED | X | X | |
| INIT | X | X | |
| ISOLATION | X | ||
| JIT | X | X | |
| MARS | X | X | |
| NIST | X | X | |
| NOT | X | X | |
| ODBCTRACE | X | ||
| ODBCV3 | X | X | |
| PARAMARRAY | X | ||
| PASS | X | X | |
| PRE | X | ||
| PREFETCH | X | ||
| RESULTARRAY | X | ||
| STMTCACHE | X | X | |
| TARGETDB | X | X | |
| TESTSQLSTATE | X | ||
| THREAD | X | ||
| TRACELEVEL | X | ||
| USECURLIB | X | ||