rs_ddlsession

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.