Replication Server System Functions

Provides reference pages for the Replication Server system functions.

• rs_autoc_on
  Updates the rs_status table to indicate that autocorrection has been set to on.
• rs_autoc_off
  Updates the rs_status table to indicate that autocorrection has been set to off.
• rs_autoc_ignore
  Updates the rs_status table to indicate that autocorrection has failed and that DML is ignored for a table.
• rs_batch_end
  rs_batch_end allows users to batch commands into non-Adaptive Server database servers. This function string stores the SQL statements needed to mark the end of a batch of commands.
• rs_batch_start
  rs_batch_start allows users to batch commands into non-Adaptive Server database servers. This function string stores the SQL statements needed to mark the beginning of a batch of commands.
• rs_begin
  Begins a transaction in a data server.
• rs_check_repl
  Checks to see if a table is marked for replication.
• rs_commit
  Commits a transaction in a data server.
• rs_datarow_for_writetext
  Provides an image of the data row associated with a text, unitext, or image column updated with the Transact-SQL writetext command, with the Client-Library function ct_send_data, or with the DB-Library™ functions dbwritetext and dbmoretext.
• rs_delete
  Deletes a row in a replicated table.
• rs_dsi_check_thread_lock
  Determines whether or not the DSI executor thread is holding a lock that blocks a replicate database process. A return value greater than 0 indicates that the thread is holding resources required by another database process, and that the thread should roll back and retry the transaction.
• rs_dumpdb
  Initiates a coordinated database dump.
• rs_dumptran
  Initiates a coordinated transaction dump.
• rs_get_charset
  Returns the character set used by a data server. This function allows Replication Server to print a warning message if the character set is not what is expected.
• rs_get_errormode
  Returns native error configuration, which determines whether or not the native error is returned directly from the replicate server.
• rs_get_lastcommit
  Returns rows from the rs_lastcommit system table.
• rs_get_sortorder
  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.
• rs_get_textptr
  Retrieves the description for a text, unitext, or image column.
• rs_get_thread_seq
  Returns the sequence number for the specified entry in the rs_threads system table.
• rs_get_thread_seq_noholdlock
  Returns the sequence number for the specified entry in the rs_threads system table, using the noholdlock option.
• rs_initialize_threads
  Sets the sequence of each entry in the rs_threads system table to 0.
• rs_insert
  Inserts a single row into a table in a replicate database.
• rs_marker
  Passes its parameter to Replication Server as an independent command.
• rs_non_blocking_commit
  Requests data servers to immediately send a positive response to a COMMIT statement without waiting for transactions to be written to disk.
• rs_non_blocking_commit_flush
  Sends an insert, delete, or update command to the data servers so that transactions that were sent through a connection configured with rs_ non_blocking_commit are saved to disk.
• rs_raw_object_serialization
  Enables Replication Server to process Java columns in serialized format.
• rs_repl_off
  Specifies whether transactions executed by the maintenance user in the Adaptive Server database are replicated.
• rs_repl_on
  Sets replication on in Adaptive Server for either a database connection or database connections.
• rs_rollback
  Rolls back a transaction. This function is reserved for future use.
• rs_select
  Selects rows for subscription materialization from the primary copy of a replicated table and, for subscription dematerialization, from the replicate copy of the table.
• rs_select_with_lock
  Selects rows for subscription materialization from the primary copy of a replicated table, using a holdlock to maintain serial consistency.
• rs_session_setting
  Sets Sybase IQ parameters and database options for the duration of the connection to the Sybase IQ replicate database.
• rs_set_ciphertext
  Enables replication of encrypted columns to an Adaptive Server table.
• rs_set_dml_on_computed
  Enables the replication of materialized computed columns to the replicate Adaptive Server database as regular columns.
• rs_set_isolation_level
  Passes the isolation level for transactions to the replicate data server.
• rs_set_quoted_identifier
  Configures a data server connection to accept quoted identifiers.
• rs_set_timestamp_insert
  Enables replication of timestamp columns to an Adaptive Server table.
• rs_setproxy
  Changes the login name in a data server.
• rs_sqldml
  A replicated function that carries SQLDML to Replication Server.
• rs_textptr_init
  Allocates a text pointer for a text, unitext, or image column.
• rs_ticket_report
  Insert ticket to the rs_ticket_history table.
• rs_triggers_reset
  Turns off triggers in Adaptive Server and Oracle.
• rs_truncate
  Truncates a table or a table partition in a replicate database.
• rs_update
  Updates a single row in a table in a replicate database.
• rs_update_threads
  Updates the sequence number for the specified entry in the rs_threads system table.
• rs_usedb
  Changes the database context in a data server.
• rs_writetext
  Modifies text, unitext, or image data in a replicate database.