Show TOC

rs_ddlsession_settingLocate this document in the navigation structure

Automatically applies several Adaptive Server session-level set options to support the replication of Adaptive Server precomputed result set DDL commands.

Examples
Example 1

Creates an instance of an rs_ddlsession_setting function string:

create function string rs_ddlsession_setting
 for sqlserver_derived_class
 output language
 'set ansinull on; set arithabort on; set arighignore off; set string_rtruncation on'
Usage
  • Replication Server executes rs_ddlsession_setting for the DSI connection to a database.
  • You do not have to execute rs_ddlsession_setting manually.
  • Replication Server executes rs_ddlsession_setting before the Data Server Interface (DSI) thread applies a DDL command.
  • rs_ddlsession_setting sets the values of Adaptive Server session-level set options to the relevant settings to allow replication of the precomputed result set DDL commands:
    • set ansinull on
    • set arithabort on
    • set arithignore off
    • set string_rtruncation on
  • rs_ddlsession_setting has function-string class scope.
  • Replication Server creates an initial rs_ddlsession_setting function string for the system-provided function-string classes during installation.
  • Replication Server uses rs_ddlsession_setting with rs_ddlsession_resetting.
  • If you use a user-created base function-string class, create a function string for rs_ddlsession_setting if you plan to use it in any way other than the default.
  • Create or customize an rs_ddlsession_setting function string at the Replication Server that is the primary site for the class.