Obtain Information Using Stored Procedures

You can obtain information about existing functions, function strings, and function-string classes in your system using stored procedures in a Replication Server RSSD.

See Replication Server Reference Manual > RSSD Stored Procedures for more information.

rs_helpfunc

rs_helpfunc displays information about system functions and user-defined functions for a Replication Server or for a particular table or function replication definition. The syntax is:

rs_helpfunc [replication_definition [, function_name]]

rs_helpfstring

rs_helpfstring displays the parameters and function-string text for functions associated with a replication definition. The syntax is:

rs_helpfstring replication_definition
	[, function_name]

rs_helpobjfstring

rs_helpobjfstring displays the parameters and function-string text for function strings associated with a standby, replicate table or stored procedure. The syntax is:

rs_helpobjfstring data_server, database, [owner.]object [,function]

rs_helpclass

rs_helpclass lists all function-string classes and error classes and their primary Replication Servers. The syntax is:

rs_helpclass [class_name]

rs_helpclassfstring

rs_helpclassfstring displays the function-string information for class-scope functions. The syntax is:

rs_helpclassfstring class_name [, function_name]