• Linux
  
• psqlodbc.so,  psqlodbcw.so should be used with #define OTL_ODBC_POSTGRESQL
• libodbcpsql.so should be used with #define OTL_ODBC
  
• Solaris
  
• libodbcpsql.so should be used with #define OTL_ODBC_POSTGRESQL
  
• Windows
• pgsqlodbc30a.dll, pgsqlodbc35w.dll should be used with #define OTL_ODBC_POSTGRESQL
  
  

#define OTL_BIGINT __int64 // VC++, Borland C++

#define OTL_BIGINT long long // GNU C++

#if defined(_MSC_VER) // VC++

#define OTL_BIGINT __int64

#define OTL_STR_TO_BIGINT(str,n)                \
{                                               \
  n=_atoi64(str);                               \
}

#define OTL_BIGINT_TO_STR(n,str)                \
{                                               \
  _i64toa(n,str,10);                            \
}
#endif

#if defined(__GNUC__) // GNU C++

#include <stdlib.h>

#define OTL_BIGINT long long

#define OTL_STR_TO_BIGINT(str,n)                \
{                                               \
  n=strtoll(str,0,10);                          \
}

#define OTL_BIGINT_TO_STR(n,str)                \
{                                               \
  sprintf(str,"%lld",n);                        \
}


#endif

• #define OTL_TRACE_LEVEL specifies a level of OTL tracing. Each type of tracing is represented by its own bit in the whole trace level unsigned  int value:
  
  
1. 0x1 -- traces the following functions of the otl_connect class (1st level of tracing): rlogon(), logoff(), commit(), rollback(), auto_commit_on(), auto_commit_off()
   
2. 0x2 -- traces otl_cursor::direct_exec(), direct execution of static SQL statements, no otl_streams (2nd level of tracing).
   
3. 0x4 -- traces the following functions of the otl_stream class: open(), close()
4. 0x8 -- traces internal "execute SQL statement" function, internal "fetch the first bacth of rows" function, internal "fetch the next batch of rows" function (3rd level of tracing).
5. 0x10 -- traces the operator >> and << functions of the otl_stream class (4th level of tracing)
6. 0x20 -- traces all otl_exception's raised by OTL.



• #define OTL_TRACE_STREAM specifies a log stream variable, or a function call that returns a file stream reference. What is defined by this #define is used as an output file stream variable inside OTL.
  
  
• #define OTL_TRACE_LINE_PREFIX can be used to override the default OTL trace line prefix: "OTL TRACE ==>". If it is more convenient to have something different from the default, say, for running a Perl script on an OTL log file to mine for patterns.
  
  
• #define OTL_TRACE_LINE_SUFFIX can be used to override the default OTL trace line suffix: "\n". If it is more convenient to have something different from the default, say, for running a Perl script on an OTL log file to mine for patterns.
  
  
• #define OTL_TRACE_ENABLE_STREAM_LABELS can be used to enable logging of otl_stream labels instead of SQL statement bodies. See The Oracle, DB2-CLI, and ODBC specific otl_stream descriptions for more detail.
  

      unsigned int my_trace_level=
        0x1 | // 1st level of tracing
        0x2 | // 2nd level of tracing
        0x4 | // 3rd level of tracing
        0x8 | // 4th level of tracing
        0x10| // 5th level of tracing
        0x20; // 6th level of tracing
     // each level of tracing is represented by its own bit, 
     // so levels of tracing can be combined in an arbitrary order.

     #define OTL_TRACE_LEVEL my_trace_level 
        // enables OTL tracing, and use my_trace_level 
        // as a trace control variable.

     #define OTL_TRACE_STREAM cerr 
        // directs all OTL tracing to cerr

     #define OTL_TRACE_LINE_PREFIX "MY OTL TRACE ==> " 
        // redefines the default OTL trace line prefix. 
        // This #define is optional

     #define OTL_TRACE_LINE_SUFFIX std::endl 
        // redefines the default OTL trace line suffix. 
        // This #define is optional