To set options for your data source, click on the Settings button in the ADABAS D ODBC Setup dialog box.
The Advanced Setup dialog is displayed:
The following fields affect the functioning of the ODBC driver when you connect to the database server the next time.
SqlMode
Switches the ODBC driver into a database system emulation.
See also Section Different SQLMODEs.
IsolationLevel
Overrides the default Isolation Level (Committed) of the ODBC driver.
For more information about locking concepts, see Section IsolationLevel or the ADABAS Reference manual.
Trace
Enables or disables the trace of SQL statements. You can make the ODBC driver create a trace file for the database session by placing an X in the Trace File field or by selecting the file name using the Select... button. All SQL statements the application issues to the DBMS will be stored in the trace file. See also Section Trace of SQL Statements.
Note:
Many file operations are executed for an enabled trace decreasing the application's performance. Therefore, the trace should be disabled after analyzing the file.
Truncate Long Columns
For the processing of LONG columns, it can be useful (see Section Processing LONG Columns) to modify the behavior of the ODBC driver.