Obtains the sort order used by a data server. This function returns a warning message if the sort order does not match that of the Replication Server, and if the sort order is not what is expected.
Creates an rs_get_sortorder function string with output language that calls the sp_serverinfo system procedure and returns the data server’s sort order.
create function string rs_get_sortorder for rs_sqlserver2_function_class output language 'sp_serverinfo server_soname'
The rs_get_sortorder function obtains the name of the sort order used by a data server. Replication Server executes this function each time it connects to the data server. If the sort order does not match that of the Replication Server, a warning message is written into the Replication Server error log. If the sort orders match, no warming message is written.
The rs_get_sortorder function has function-string-class scope.
Replication Server creates an initial rs_get_sortorder function string for the system-provided function-string classes during installation.
If you use a user-created base function-string class, you must create an rs_get_sortorder function string.
If you need to create or customize an rs_get_sortorder function string, do so at the Replication Server that is the primary site for the class.
The default rs_get_sortorder function string for the <rs_sqlserver_function_class> and <rs_default_function_class> classes calls the Adaptive Server stored procedure sp_serverinfo with the argument< server_soname>.
An rs_get_sortorder function string should return a string with the name of a valid SAP-supported sort order. Valid SAP sort orders for a given character set are defined in the release directory in charsets/charset_name/sortorder.srt, where <charset_name> represents the name of a supported character set and <sortorder> represents the name of a supported sort order for the character set. For example, the file charsets/iso_1/nocase.srt defines the “nocase” sort order for the iso_1 character set.