dd_paths Table

The dd_paths table defines the paths to be taken by replicated information in a CDDS from the originating (source) database to a final target database. On each database, this table specifies where to propagate a change, based on the database where it originated:

Column Name	Data Type	Description
cdds_no	smallint not null	Identifies the CDDS.
localdb	smallint not null	Identifies the current database in the propagation path.
sourcedb	smallint not null	Identifies the database where the change originated.
targetdb	smallint not null	Identifies the next database to which the change must be propagated.
final_target	smallint not null	Indicates that the target database is the final target in this path. This column is reserved for future use.