![Implicit conversion between BIT and CHAR/VARCHAR data types supported [CR 451862]](arrow-left.gif){kind=icon}
![LOAD TABLE FORMAT syntax correction [CR 445737]](arrow-right.gif){kind=icon}
The following was omitted from the section “Using ODBC Data Sources on UNIX” in Chapter 3, “Sybase IQ Connections.”
To create an ODBC trace file, you must set the environment variables ASA_ODBCTRACE_VERBOSE and ASA_ODBCTRACE_FILE, for example:
$ setenv ASA_ODBCTRACE_VERBOSE ALL $ setenv ASA_ODBCTRACE_FILE /bluesun/fiona/odbctrace.out $ dbisql -c "dsn=J123456" -nogui
On UNIX and Linux systems, use the libdbodbc9.so driver and leave it up to the driver to choose the multi-threaded or non-threaded driver. Tracing capability exists in the switch (libdbodbc9.so), not in the individual drivers (libdbodbc9_n.so or libdodbc9_r.so). If you change the driver to point to the _r version, you are taking the switch out of the call sequence, preventing the tracing.
