Table Tab

You must set subscriber table options before configuring other subscriber options.

An incoming message does not have to contain data for all the columns defined in the subscriber table. An adapter can be configured to expect only a subset of the columns. The adapter checks the repository for attributes defined in the class object definition of the subscriber table. When a message arrives, the adapter iterates through the attributes in the class object definition and looks for those same attributes in the incoming message.

Subscriber table names can be qualified with a schema name, such as SCOTT.EMP. To access tables in other schemas, the database user defined in the adapter Connection tab must have the proper set of permissions granted. For more information, see TIBCO ActiveMatrix Adapter for Database Concepts.

When you configure the destination table, you only subscribe to columns that can be updated. If you subscribe to a column that cannot be updated and a message arrives with no data for that column, a NULL value will be written to that column. For example:

• If a source table is configured to send data for columns, c1, c2 and c3, and the destination table is configured to receive data for columns c1, c2, c3, c4, and c5, columns c4 and c5 will be ignored and take on whatever default values they are supposed to have, regardless of the TIBCO ActiveEnterprise message or XML message wire format.

• If a source table is configured to send data for columns, c1, c2, and c3, and the destination table is configured to receive data for columns c1, c2, and c3 but not configured to receive data for columns c4 and c5, columns c4 and c5 will retain the defaults applicable to both tables.

Note: When the publishing table is configured to use parent-child relationships, the subscriber adapter must use the same repository as the publisher adapter.

Figure 84: Subscription Service: Table Tab

Icons

You can use the table icons to create, edit, and organize the tables. See Publication Service Tabs, Table Tab, Icons for more information.

Check boxes

Check boxes are used for working on child columns and receiving the table columns. See Publication Service Tabs, Table Tab, Check boxes for more information.

Columns

See Publication Service: Table Columns to get more information about the table columns.