Specifying source tables and target tables

This task is part of the larger task of creating an upload subscription. When you have completed these steps, return to Creating an upload subscription.

You must define at least one table for every upload subscription.

Procedure

To add a table to the subscription:

  1. On the Identification page of the Create Upload Subscription notebook, click Define subscription. The Define Replication Subscription window opens.

  2. In the Define Replication Subscription window, click Add. The Add Table window opens.

  3. In the Add Table window, use the Table list to select the replication source to add to this subscription.

    Click Filter ... to change the source filter used to limit the available tables in the table list. The Filter window opens.

    The % symbol is a wildcard. Typing % in the Source schema and Source table fields displays all available tables in the table list.

  4. In the Target schema field, specify the schema that the table will have on the mobile device. If you do not specify a schema, by default the system uses the schema of the source table.

  5. In the Target table field, specify the name that the table will have on the mobile device. If you do not specify a name, by default the system uses the name of the source table.

  6. Optional: Select the Encrypt on device checkbox. This enables encryption on the mobile device database.
  7. Optional: Select the Use Constraints defined in selected DB2 source checkbox. This enables the constraints from the selected DB2 source table for the target table.

  8. Optional: Select the Use Indexes defined in selected DB2 source checkbox. This enables the indexes from the selected DB2 source table for the target table.

  9. Click Add to add the replication source to the subscription. Click Close to close the Add Table window.

Related concepts

Related tasks