Passes the isolation level for transactions to the replicate data server.
create function string rs_set_isolation_level for sqlserver_derived_class output language 'set transaction isolation level?rs_isolation_level!sys_raw?'
The rs_set_isolation_level function passes the transaction isolation level to the replicate data server, and executes every time the DSI connects to the replicate data server if a value has been set for dsi_isolation_level. Replication Server does not execute rs_set_isolation_level if the value of dsi_isolation_level is default or has not been set
Use alter connection or create connection with the dsi_isolation_level parameter to set the value for the variable rs_isolation_level. The supported Adaptive Server values are 0, 1, 2, and 3. Replication Server supports all other isolation level values supported by other data servers.
If the value for dsi_isolation_level is default or has not been set, Replication Server uses the transaction isolation level of the target data server. See Select Isolation Levels in the Administration Guide Volume 2 for a description of Replication Server support for isolation levels.
Replication Server executes rs_set_isolation_level immediately after executing the rs_usedb function-string command.
The rs_set_isolation_level function has function-string class scope.
Replication Server creates an initial rs_set_isolation_level function string for the Adaptive Server and default function-string classes during installation.
If you use a nondefault function-string class and you use the parallel DSI feature, create a function string for the rs_set_isolation_level function. The modified function string must contain the variable rs_isolation_level.
Create or customize an rs_set_isolation_level function string at the Replication Server that is the primary site for the class.