Show TOC

rs_get_sortorderLocate this document in the navigation structure

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.

Examples
Example 1

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'
Usage

  • 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.

Related Information