Exporting set Options from a Login Trigger

The SAP ASE server enables set options inside login triggers to remain valid for the entire user session.

The following set options are automatically exported:

  • altnames

  • ansi_permissions

  • ansinull

  • arithabort [overflow | numeric_truncation]

  • arithignore [overflow]

  • cis_rpc_handling

  • close on endtran

  • colnames

  • command_status_reporting

  • dup_in_subquery

  • explicit_transaction_required

  • fipsflagger

  • flushmessage

  • fmtonly

  • forceplan

  • format

  • nocount

  • or_strategy

  • prefetch

  • proc_output_params

  • proc_return_status

  • procid

  • quoted_identifier

  • raw_object_serialization

  • remote_indexes

  • replication

  • rowcount

  • self_recursion

  • showplan

  • sort_resources

  • statistics io

  • statement_cache

  • strict_dtm_enforcement

  • string_rtruncation

  • textptr_parameters

  • transactional_rpc

  • triggers