Options for Sybase Open Client and JDBC connection compatibility with Adaptive Server Enterprise
Option Setting
allow_nulls_by_default Off
ansi_blanks Off
ansi_substring On
ansinull On
chained Off
continue_after_raiserror On
escape_character Off
on_tsql_error Continue for jConnect connections
time_format HH:NN:SS.SSS
timestamp_format YYYY-MM-DD HH:NN:SS.SSS
tsql_outer_joins Off
tsql_variables On