Show TOC

rs_get_textptrLocate this document in the navigation structure

Retrieves the description for a <text>, <unitext>, or <image> column.

Examples
Example 1

Creates an rs_get_textptr function string for the <repcopy> column in the <blurbs> table. The function string name, copy, is the name of the <text>, <unitext>, or <image> column in the replication definition.

create function string
 blurbs_rep.rs_get_textptr;copy
 for sqlserver2_function_class
 output language
 'select repcopy from blurbs
 where au_id = ?au_id!new?'
Usage

  • Replication Server calls rs_get_textptr to retrieve a <text>, <unitext>, or <image> column description before it sends data with the Client-Library function ct_send_data.

  • rs_get_textptr has replication definition scope.

  • When you create a replication definition, Replication Server generates an rs_get_textptr function string for the <rs_sqlserver_function_class> and <rs_default_function_class >classes for each replicated <text>, <unitext>, or <image> column in the replication definition.

  • If you use a user-created base function-string class, you must create an rs_get_textptr function string for each replicated <text>, <unitext>, or <image> column included in the replication definition.

  • Create or customize an rs_get_textptr function string at the Replication Server where you created the replication definition.

  • rs_get_textptr must return a <text> or <unitext> column description for a <text>, <unitext>, or <image> column in a specified row. The <text> or <unitext> column description must conform to Open Server requirements for returning an “I/O descriptor structure.” For information about this structure, refer to the Open Server Server-Library/C Reference Manual.

  • ExpressConnect for Oracle and ExpressConnect for HANA DB do not use LOB pointers to manage LOB data. Consequently, the Replication Server system functions used to managing LOB pointers are unavailable to ExpressConnect for Oracle and ExpressConnect for HANA DB. These functions–which include rs_get_textptr, rs_textptr_init, and rs_writetext–are visible to ExpressConnect, but their use is ignored by Replication Server.

Related Information