DBMAN Directive Settings

This table shows all of the SQL compiler directive options and the DBMAN preprocessor options with which they are valid.

Directive DBMAN=ODBC DBMAN=JDBC
ACCESS X
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 X1
RO_CURSOR X
TRANSACTION X
UPD_CONCURRENCY X
UPD_CURSOR X
BIND X
CHECK X X
CHECKDUPCURSOR X X
CHECKSINGLETON X X
CLOSE_ON_COMMIT X X
CONCAT X 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 X
ESQLVERSION X
FIPSFLAG X
GEN-CC2 X
GEN-CLASS-VAR X
GEN-HV-FROM-GROUP X X
GEN-INIT-FLAG X X
GEN-SQLCA 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
OPTIMIZECURSORS X
OPTION X X
OPTPER X
PARAMARRAY X
PASS X X
PICXBINDING X X
PRE X
PREFETCH X
QUALFIX X X
RESULTARRAY X
SAVE-RETURN-CODE X X
SPDISPLAY X
STMTCACHE X X
TARGETDB X X
TESTSQLSTATE X
THREAD X
TIME X X
TIMEDELIM X X
TRACELEVEL X
TSTAMPSEP X X
USECURLIB X
USER-SQLDA X
XAID X

1 SQL Server only