Adaptive Server version 12.5.4 enables options set inside login triggers to remain valid for the entire user session.
The following set options are automatically exported:
showplan
arithabort [overflow | numeric_truncation]
arithignore [overflow]
colnames
format
statistics io
procid
rowcount
altnames
nocount
quoted_identifier
forceplan
fmtonly
close on endtran
fipsflagger
self_recursion
ansinull
dup_in_subquery
or_strategy
flushmessage
ansi_permissions
string_rtruncation
prefetch
triggers
replication
sort_resources
transactional_rpc
cis_rpc_handling
strict_dtm_enforcement
raw_object_serialization
textptr_parameters
sort_merge
remote_indexes
explicit_transaction_required
statement_cache
command_status_reporting
proc_return_status
proc_output_params