Replication definitions identify specific tables for replication and, in some cases, specify a subset of the columns you want to replicate. This procedure shows you how to create one or more replication definitions for an ASE source table.
Expand ASE <server name> | <database name> | Tables.
Click on the table where you want to create a replication definition, and double-click Add Replication Definition. A property sheet for the replication properties appears.
Click the Columns tab and define a key for the source table.
To define a key, click on the column icon for the column you want to use as the key. The image changes to a key icon. If the scripts were created in PowerDesigner with the primary key option, the key should already be defined.
Click the Advanced tab and add the target table owner, if necessary. If you created the Sybase IQ database with the default owner, this value should be DBA.
Click OK.
Note
When you create a replication definition, RSM may display
an error message similar to this message: "Replication
definition <table name> requires at least one column in the primary
key."
Every replication definition requires that one column be defined as a key. Within the replication definition, select the Columns tab and click on the column name that should be defined as the key for the table. The icon should change to the image of a key.
