Change Subscription -- Fields and controls

" " Subscription name
" " Target server
" " Apply qualifier
" " Source table
" " Target table
" " Create table
" " Add
" " Change
" " Remove
" " Advanced
" " SQL
" " Timing
" " OK
" " Cancel



" " Subscription name

Type a subscription set name for the source and target table combination.

This name:

" " Target server

This field displays a DB2 alias from a list of DB2 aliases cataloged on the system. The default is the alias of the source server. To select another server, either:

" " Apply qualifier

Type an apply qualifier name for the current subscription. This field does not contain a default value.

This name:

" " Source table

This field displays the source tables that you selected from the list of replication tables.

" " Target table

This field displays a list of target tables named to match the corresponding source tables by default. You can substitute a different name for each table by clicking on the name, then typing over it. You can use an existing name or a new name. If you choose a new name, you will need to create the table by selecting the Create table check box adjacent to the source and target table combination.

" " Create table

Select this check box to create the source and target table combination.

" " Add

Click on this push button to open the Add window so you can add one or more source and target table combinations to the current subscription. You can also specify whether you want to create the target table if it does not currently exist.

" " Change

Click on this push button to open the Change window and change the target table. You can change the target table to an existing target table or create a new target table.

" " Remove

Click on this push button to remove the selected source and target table combinations from the subscription set. A Remove Confirmation window enables you to confirm your deletions.

" " Advanced

Click on this push button to open the Advanced Subscription Definition notebook so that you can specify the target type, target columns, and target rows for any of the tables in the subscription.

" " SQL

Click on this push button to open the SQL window so that you can add or remove subscription SQL run-time statements.

" " Timing

Click on this push button to open the Subscription Timing notebook so that you can specify when and how often to replicate the subscription.