Show TOC

rs_ddlsession_resettingLocate this document in the navigation structure

Automatically resets several Adaptive Server session-level set options to the default values after the replication of Adaptive Server DDL commands.

Example 1

Creates an instance of an rs_ddlsession_resetting function string.

create function string rs_ddlsession_resetting
 for sqlserver_derived_class
 output language
 'set ansinull off; set arithabort on; set arighignore off; set string_rtruncation off'
  • Replication Server executes rs_ddlsession_resetting for the DSI connection to a database.
  • You do not have to execute rs_ddlsession_resetting manually.
  • Replication Server invokes rs_ddlsession_resetting after the Data Server Interface (DSI) thread completes processing of DDL commands.
  • rs_ddlsession_resetting resets the session-level options to their default values after processing the DDL commands:
    • set ansinull off
    • set arithabort on
    • set arithignore off
    • set string_rtruncation off
  • rs_ddlsession_resetting has function-string class scope.
  • Replication Server creates an initial rs_ddlsession_resetting function string for the system-provided function-string classes during installation.
  • Replication Server uses rs_ddlsession_resetting with rs_ddlsession_setting.
  • If you use a user-created base function-string class, create a function string for rs_ddlsession_resetting if you plan to use it in any way other than the default. For example, you can create a customized function string for rs_ddlsession_resetting to ensure that the session-level set option values revert to what you previously set.
  • Create or customize an rs_ddlsession_resetting function string at the Replication Server that is the primary site for the class.