cdr alter

The cdr alter command puts the specified tables in alter mode.

Syntax


1  cdr alter?  %Connect Option  (1)
1  --on
1  --off
2 + database:owner.table
Notes:
Element Purpose Restrictions Syntax
database The name of the database that contains the table The database server must be registered with Enterprise Replications. Long Identifiers
owner User ID of the owner of the table Long Identifiers
table Specifies the name of the table to put in alter mode The table must be an actual table. It cannot be a synonym or a view. Long Identifiers

The following table describes the options to cdr alter.

Long Form Short Form Meaning
--on -o Sets alter mode on.
--off -f Unsets alter mode.

Usage

Use this command to place a table in or out of alter mode. Use alter mode when you need to alter an attached fragment to the table or you want to perform other alter operations manually.

You can run this command from within an SQL statement by using the SQL administration API.

Examples

The following example puts table1 and table2 in alter mode: 
cdr alter --on db1:owner1.table1 db2:owner2.table2