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.