The cdc_set_fullrowlogging() function

Enables or disables full-row logging for a table.

Purpose

You must run this function to enable full-row logging on a table before you can start capturing data from it.

The DB_LOCALE environment variable must be set to the same locale as the database locale when you run this function.


1  cdc_set_fullrowlogging ( "database:owner.table_name"  , logging  )

Function arguments

Table 1. The cdc_set_fullrowlogging() arguments
Argument Data Type Description
database:owner.table_name LVARCHAR The qualified name of the table. The qualified name includes the following elements:
database
The name of the database in which the table exists.
owner
The name of the owner of the table.
table
The name of the table.
logging INTEGER
  • 0 Disable full-row logging
  • 1 Enable full-row logging

Usage

Use the cdc_set_fullrowlogging() function to enable full-row logging on a table from which you intend to perform data capture. This function must be run as user informix. You must stop capturing data from a table using cdc_endcapture() before you disable full-row logging using cdc_set_fullrowlogging(). Without cdc_endcapture(), the disabling of full-row logging will fail with error "19816: Cannot perform this operation on a table defined for replication". Placeholder updates are fully logged. Logging remains enabled when the Change Data Capture session is closed.

You can check the status of logging by running the oncheck -pT command. The Tblspace flags section of the oncheck -pT output shows the following text if logging is enabled: TBLspace flagged for Log Snooping.

You must call this function from a client application. You cannot call this function from a user-defined routine that runs within the database server.

Return values

If successful, returns 0.

If unsuccessful, returns an integer corresponding to an error code and updates the syscdcsess table with the error information.