rs_ddlsession_resetting

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

Examples

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'

Usage

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.