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. If the dsi_isolation_level is the default value, rs_set_isolation_level is not executed.
Use the alter connection or create connection with the set_isolation_level option to 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 no value is supplied for rs_isolation_level, Replication Server uses the isolation value of the target data server.
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.