You use the create subscription command to replicate data by subscribing to a replication definition. There are three methods for creating a subscription:
Atomic
Nonatomic
No materialization
You can use a where clause to replicate only certain rows from the primary table, based on values for the searchable columns specified in the table replication definition. If you do not provide a where clause, all rows are replicated. See “Using the where clause” for more information.
If you are using Adaptive Server Enterprise version 11.5 or later, you can include the subscribe to truncate table keywords to reproduce execution of the truncate table command at the destination database. See “Enabling replication of truncate table” for more information.
create subscription automatically
truncates text, unitext,
and image data larger than 32K.
Refer to Chapter 3, “Replication Server Commands,” in the Replication Server Reference Manual for details on using the create subscription command. See Chapter 9, “Managing Replicated Tables” for more information on creating table replication definitions.
