Show TOC

alter function string classLocate this document in the navigation structure

Alters a function-string class, specifying whether it should be a base class or a derived class.

Syntax
alter function string class <function_class
>   set parent to {<parent_class> | null}
Parameters
function_class

The name of an existing function-string class to be altered.

set parent to

Designates an existing class as a parent for the class you are altering; or, with the null keyword, designates that the class should be a base class.

parent_class

The name of an existing function-string class you designate as the parent class for a new derived class. <rs_sqlserver_function_class> may not be used as a parent class.

null

Specifies that the class should be a base class.

Examples
Example 1

Specifies that <sqlserver2_function_class> should become a derived class, inheriting function strings from the parent class <rs_default_function_class>:

alter function string class
 sqlserver2_function_class
 set parent to rs_default_function_class
Example 2

Specifies that the derived function-string class named <rpc_xact> should be a base class:

alter function string class rpc_xact
 set parent to null
Usage
  • Use alter function string class to change a derived function-string class to a base class, to change the parent class of a derived class, or to change a base class to a derived class.

  • The primary site for a derived class is the same as its parent class. Alter derived classes at the primary site of the parent class. However, if the parent class is a system-provided class, <rs_default_function_class> or <rs_db2_function_class>, the primary site for the derived class is the Replication Server where you created the derived class.

  • See create function string for more information about alter function string class.

  • For more information about function-string classes, function strings, and functions, see the Replication Server Administration Guide Volume 2.

  • Replication Server distributes the altered function-string class to qualifying sites through the replication system. The changes do not appear immediately at all such sites because of normal replication system lag time.

Permissions

alter function string class requires “sa” permission.