Sybase Adaptive Server Anywhere - Page 632

SET OPTION statement
614
Caution
Changing option settings while fetching rows from a cursor is not
supported, as it can lead to ill-defined behavior. For example, changing
the DATE_FORMAT setting while fetching from a cursor would lead to
different date formats among the rows in the result set. Do not change
option settings while fetching rows.
♦ SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise. Adaptive
Server Anywhere does support some Adaptive Server Enterprise options
using the SET statement.
♦ Set the date format option to on.
SET OPTION public.date_format = ’Mmm dd yyyy’;
♦ Set the date format option to off.
SET OPTION public.date_format =;
♦ Set the ’wait for commit’ option to on.
SET OPTION waitefor_commit = ’on’;
1. EXEC SQL SET OPTION :user.:option_name = :value;
2. EXEC SQL SET TEMPORARY OPTION Date_format =
’mm/dd/yyyy’;
Standards and
compatibility
Examples
Embedded SQL
Examples