Defining a join for a replication source

Use the Define Join window to define a join for one or more replication sources. You can define joins for any defined replication source, including user tables and consistent change data tables.

Fields and controls

Authorities and privileges



To define a join for a replication source:

  1. Open the Define Join window.

  2. In the CREATE VIEW field, type the CREATE VIEW SQL statement for the join.

  3. In the FROM field, type the FROM SQL statement for the view.

  4. If you want to use a predicate, type the WHERE SQL statement in the WHERE field.

  5. Click on OK to define a join. The Run Now or Save SQL window opens. You can choose to run your SQL request now or run it later.

  6. Refresh and verify your object.

    After verifying your object, remember to start or reinitialize the Capture program from your command line processor so that it will recognize the new replication source join definition. See the Replication Guide and Reference for more information.



Related information