If you specify the SQL Mode option, you can use the MaxDB ODBC driver in a different SQL mode. This means that the driver can process not only the ODBC and MaxDB-specific SQL syntax, but also the ORACLE or DB2 syntax, for example.
Specifying this option can simplify the way SQL statements are customized when ODBC applications are migrated from other database systems.
...
1. Start the ODBC Data Source Administrator by choosing Start ® Settings ® Control Panel ® Administrative Tools ® Data Sources.
2. Choose Add.
3. Choose the MaxDB ODBC driver and then Finish.
4. Specify the name of the data source, the name of the database instance, and the name of the database computer. Choose Options.
5. In the SQL Mode field, choose an SQL mode.
6. Confirm the windows until the ODBC Data Source Administrator closes.
The next time that you connect to the database computer using this data source, the MaxDB ODBC driver operates in the selected SQL mode.