Returns LOB column replication status; enables or disables replication for LOB columns within marked tables.
pdb_setrepcol [ { enable | disable | tablename[, colname[, { enable | disable[, force] } ] ] | all, { enable | disable[, force] } } ]
owner.table
The tablename option can be delimited with quote characters to specify the character case.
"Owner".table
"Owner"."Table"
Each mixed-case element of the tablename option must be delimited separately, as shown in the previous example.
"table name"
owner."table name"
owner."table.name"
"table.owner"."table.name"
The colname option can be delimited with quote characters to specify the character case.
"Colname"
"COLname"
When the force keyword follows the disable keyword, the pdb_setrepcol command immediately disables replication for the specified LOB column. When the force keyword follows the disable keyword and the all keyword, the pdb_setrepcol command immediately disables replication for all marked LOB columns in marked tables in the primary database.
pdb_setrepcol
This command returns replication information for all enabled LOB columns in marked tables in the primary database.
pdb_setrepcol authors
This command returns replication information for all LOB columns defined for the table authors in the primary database.
pdb_setrepcol authors, picture
This command returns replication information for the column called “picture” in the table authors in the primary database.
pdb_setrepcol authors, picture, enable
This command enables replication for the column picture in the table authors in the primary database.
pdb_setrepcol all, disable
This command disables replication for all LOB columns in all marked tables in the primary database.
If a column is renamed or dropped and a new column with the original name is created, you must explicitly enable or disable replication from this new column because the new column has no replication status related information from the original column. The marking information is maintained internally based on column number, not column name.
When pdb_setrepcol is invoked, its function is determined by the keywords and options you specify.
When multiple keywords or options are specified, each must be separated by a comma. Blank space before or after a comma is optional. For example:
pdb_setrepcol all, disable
When you specify a column name in the pdb_setrepcol command, you must use the name of a valid LOB column.
If a column name in the primary database is the same as a keyword, it can be identified by adding the string col= to the beginning of the column name. For example:
pdb_setrepcol tablename, col=enable, disable
If you enable LOB column replication with the pdb_setrepcol command, do not configure Replication Agent to convert date or time datatypes in the primary database.
If pdb_setrepcol is invoked with no option, it returns a list of all LOB columns for which replication is enabled in the primary database.
If pdb_setrepcol is invoked with a table name, it returns information about the enabled status of all the LOB columns in the specified primary table.
If pdb_setrepcol is invoked with the enable keyword, it returns a list of all LOB columns for which replication is enabled in the primary database.
If pdb_setrepcol is invoked with the disable keyword, it returns a list of all LOB columns for which replication is disabled in the primary database.
For LOB columns listed as disabled, transactions are not captured for replication.
When pdb_setrepcol is invoked with a valid primary table name and valid LOB column name, with no keywords, it returns information about the enabled status of the specified LOB column in the specified table in the primary database.
If pdb_setrepcol is invoked with the all keyword and the enable keyword, it enables replication for all LOB columns in marked tables in the primary database.
If pdb_setrepcol is invoked with the all keyword and the disable keyword, it disables replication for all LOB columns in marked tables in the primary database.
If pdb_setrepcol is invoked with a table name and LOB column name and the enable keyword, it enables replication for the specified LOB column in the primary database.
If pdb_setrepcol is invoked with a table name and LOB column name and the disable keyword, it disables replication for the specified LOB column in the primary database.
If the table name and LOB column name combination you specify does not exist in the primary database, the pdb_setrepcol command returns an error.
If the Replication Agent transaction log does not exist in the primary database (UDB) or the RASD is not initialized (Oracle or Microsoft SQL Server), the pdb_setrepcol command returns an error.
If pdb_setrepcol is invoked with a table containing a “DATE” column, the primary key in the primary table must not include the “DATE” column. This is true for Replication Agent for UDB but not for Replication Agent for Oracle or Microsoft SQL Server.