Previous Topic Next topic Print topic


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=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
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
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
OPTIMIZESPCURSORS X
OPTION X X
OPTPER X
PARAMARRAY X
PASS 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

Previous Topic Next topic Print topic