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.