Schema Tab

Each adapter service has the Schema tab. You can use this tab to specify tables, stored procedures, functions, or packages.

In Publication Service and Subscription Service, you can use this tab to specify the schema information and use the tool icons in this tab to fetch and configure tables. The added tables are displayed in the Table panel.

The following figure shows the Schema tab of Publication Service:

The following table shows the Schema tab of Subscription Service:

In custom RPC Service, the Schema tab displays the stored procedure, function, and package information. The following figure shows the Schema tab of custom RPC Service:

In Request-Reply RPC Service and standard RPC Service, the Schema tab displays the default schema information. The following figure shows the Schema tab of Request-Response Service in Request Reply mode:

The following figure shows the Schema tab of standard RPC Service:

For Publication Service and Subscription Service, the Schema tab includes the following tool icons:

Add Table : to add a root table, click this icon. For Publication Service, this table is the source table; for Subscription Service, this table is the destination table, which is used to receive data.
Add Child table : to add a secondary table to the source table or destination table, click this icon.
Re-find schema from database : to refresh stored table schema information in TIBCO Business Studio by retrieving new information from the database, click this icon.
Load table schema from database : to load a database table schema and convert it into an AE schema, click this icon.
Note: This icon is available only for Publication Service.
Delete Table: to delete a table, right-click the table, and from the pop-up menu, click Delete Table. If the table has child tables, its child tables are also removed.

For Publication Service and Subscription Service, the fields in the Table view of AE Schema are listed in the following table:

Name	Description
Allow Key Columns Only	Use this check box to determine whether child columns can be joined to a column that is not key. Be default, this check box is selected. The status is as follows: Selected: child columns are joined only to a key column. Cleared: child columns can be joined to any column.
Tables and Columns	Loaded tables and columns.
Join To	Name of a parent table column to be joined for parent-child relationships.
User Key	Click this check box to define the column as a user key.
Update Trigger	Fires a trigger when an UPDATE statement changes a value in the column. This check box is available only for Publication Service. Note: Only the following databases are supported in the Update Trigger option: Oracle SQL Server DB2 UDB, AS400, or OS390 Sybase
AE Type	Primitive type mapped to the TIBCO ActiveEnterprise type.

For Request-Response Service, the tables and columns displayed in the AESchema table are listed in the following table:

Field	Description
Classes and Fields	Loaded classes and fields.
AE Type	Primitive type of the AE Schema class or field.