BackPrevious Topic  Next TopicNext

Pre-join Editor Dialog Box

You can use the Pre-join Editor dialog box to edit pre-joins in the selected data source of the current catalog. This topic describes the options in the dialog box.

Designer displays the Pre-join Editor dialog box when you select Pre-join on the Catalog Manager toolbar, then select a data source and select OK.

Pre-join Editor

You see the following options in the dialog box:

Add Table

Select to open the Add Tables/Views/Queries dialog box to add or remove data resources such as tables, views, synonyms, queries, imported SQLs, stored procedures, and user-defined data sources. Designer displays the added resources as tables in the editing panel.

Save

Select to save all the changes in the dialog box.

Edit Paths

Select to open the Edit Pre-join Paths dialog box to define pre-join paths.

Arrange

Select to organize the tables that you add to the dialog box.

Editing panel

Designer displays the tables that you add for defining the joins in this panel. You can make joins between the tables by using mouse drag: point to one column in the source table, select and hold the mouse button, then move the pointer to the other column in the target table and release the mouse button. You can then see a green line with a join icon Join button linking the two columns. If you want to further edit a join, double-click its join icon Join button, Designer then displays the Join Options dialog box for you to edit it. After creating joins between the tables, you can use them to define paths.

Help

Select to view information about the dialog box.

Back to top

BackPrevious Topic  Next TopicNext