define subscription Command

Use define subscription to create a subscription with bulk materialization.

Execute the define subscription command at the Replication Server that is managing the database where the data is to be replicated. define subscription sets the subscription status to DEFINED. The syntax for define subscription is:

define subscription subscription
for {table_rep_def | function_rep_def 
	publication pub_name | database replication definition db_repdef
	with primary at data_server.db
with replicate at data_server.db
[where search_conditions]
[subscribe to truncate table]

where subscription is the name of the subscription to define, table_rep_def is the name of the table replication definition the subscription is for, function_rep_def is the name of the function replication definition the subscription is for, pub_name is the publication the subscription is for, db_repdef is the database replication definition the subscription is for, and data_server.db identifies the primary or replicate database.

The subscription name must be unique for the replication definition and replicate database.

See Replication Server Reference Manual > Replication Server Commands > define subscription.