Server options changed by ODBC

The SAP Sybase IQ ODBC driver sets some temporary server options when connecting to a SAP Sybase IQ database. The following options are set as indicated.

• date_format – yyyy-mm-dd
• date_order – ymd
• isolation_level – based on the SQL_ATTR_TXN_ISOLATION/SA_SQL_ATTR_TXN_ISOLATION attribute setting of SQLSetConnectAttr. The following options are available.

  SQL_TXN_READ_UNCOMMITTED
  SQL_TXN_READ_COMMITTED
  SQL_TXN_REPEATABLE_READ
  SQL_TXN_SERIALIZABLE
  SA_SQL_TXN_SNAPSHOT
  SA_SQL_TXN_STATEMENT_SNAPSHOT
  SA_SQL_TXN_READONLY_STATEMENT_SNAPSHOT

• time_format – hh:nn:ss
• timestamp_format – yyyy-mm-dd hh:nn:ss.ssssss
• timestamp_with_time_zone_format – yyyy-mm-dd hh:nn:ss.ssssss +hh:nn

To restore the default option setting, execute a SET statement. Here is an example of a statement that will reset the timestamp_format option.

set temporary option timestamp_format =