LOGIN_PROCEDURE database options reset by ODBC [CR 393543]

The following option settings are explicitly set by the Sybase jConnect driver and the iAnywhere ODBC driver in accordance with the ODBC specification:

• Time_format = 'hh:nn:ss'

• Timestamp_format = 'yyyy-mm-dd hh:nn:ss.ssssss'

• Date_format = 'yyyy-mm-dd'

• Date_order = 'ymd'

• Isolation_level = 0

These options will overwrite settings by the LOGIN_PROCEDURE database option. Because these option settings are mandated by the ODBC specification, ODBC applications, including DBISQL applications, must explicitly set these options if they want different behavior. This could be done using the ODBC connection parameter InitString, for example:

iqdsn -wu foo -c
"uid=dba;pwd=sql;eng=foo;InitString='SET OPTION
PUBLIC.DATE_ORDER = ' ' DMY ' ' ' ”