Adaptive Server’s default behavior is to reset any set parameter changes that are set by a trigger or system procedure after they finish running. Enabling set export_options allows you to retain the session settings that are set by a system procedure or trigger for the duration of the session. The syntax for set export_options is:
set export_options [on | off]
For example, this enables set export_options:
set export_options on
This disables set export_options and returns Adaptive Server to the default behavior:
set export_options off
