Select Tables Screen (Magic xpi 4.9)
The Select Tables screen shows a list of the tables found in the database.
To use the Select Tables screen:
-
Select the required DB operation from the DB Operation drop-down list. This drop-down list is only enabled when Database is used in the Destination pane and the UPSERT property is set to No in Database Schema Properties pane.
When the UPSERT property is set to Yes in the Database Schema Properties pane, the DB Operation drop-down list will be disabled and will only show UPSERT as the chosen option.
-
In the Available Tables field, select the table and click the Add button. The selected table moves to the Selected Tables field. To remove a table from the Selected Tables column, select a table and click the Remove button.
|
|
For Source objects you can select more than one table. For Destination objects you can only select one table.
|
-
Click Next to display the Select Columns screen.
The Select Tables screen contains the following additional fields:
|
|
|
|
Filter Definitions Only
|
This check box lets you select the owner and the tables that will be fetched for the Database wizard's Select Table operation. You can select a specific owner and view all of this owner's tables, or you can select only a subset of these tables. You can also select All to view all tables from all owners, and then select the tables to be used. This may take a long time if there is a large number of tables.
|
|
Available List By Owner
|
This drop-down list enables you to filter the list according to a certain owner, or to display all of the tables. Note that there will also be system tables in the list. Select All to display all available tables.
|
