Adding NUMBER_OF_UPDATED_ROW After Migration

Number of Updated Row is a new function that indicates how many records Subscription Service has updated in a database. TIBCO ActiveMatrix Adapter for Database 7.0 and earlier versions do not support this function. After you create an adapter configuration in a project, an AESchemas schema without the NUMBER_OF_UPDATED_ROW property is generated.

Even if you migrate your projects from TIBCO ActiveMatrix Adapter for Database 7.0 and earlier versions to TIBCO ActiveMatrix Adapter for Database 7.1, the AESchemas schema still does not contain the NUMBER_OF_UPDATED_ROW property. You can manually add the NUMBER_OF_UPDATED_ROW property to the ADB_SUBSCRIBER_STATUS class schema, and then migrate the project to TIBCO Business Studio. For details on how to add the property in TIBCO Designer, see TIBCO ActiveMatrix Adapter for Database Configuration and Deployment.

If you want to import your projects from TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) 1.1 and earlier versions to TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) 1.2, the AE schema does not contain the NUMBER_OF_UPDATED_ROW property. If you want to check the number of updated rows, you can manually add the NUMBER_OF_UPDATED_ROW property to the ADB_SUBSCRIBER_STATUS class schema.

Note: You can use the Number of Updated Row function only when a reply subject is specified in a Business process.

Procedure

  1. In the Project Explorer view, expand AESchemas > ae > ADB > adbmetadata.schema > Classes.
    The Classes folder is opened in the editor.
  2. In the All Classes panel, select the ADB_SUBSCRIBER_STATUS schema and click Add Attribute.
    An attribute is added to the ADB_SUBSCRIBER_STATUS schema. You can configure this attribute in the Configuration panel on the right.
  3. In the Configuration panel, specify the following options:
    • Type NUMBER_OF_UPDATED_ROW in the Name field.
    • Click Browse next to the Return Type field and select ae.schema and the i4 type.

    • Select the Readable and Writable check boxes.
  4. Click Save on the menu bar.
    The NUMBER_OF_UPDATED_ROW property is added.

Result

If you do not want to use the NUMBER_OF_UPDATED_ROW feature or import projects created in TIBCO ActiveMatrix Adapter for Database 7.0 and earlier versions, you do not have to add this property.
Contents
Search Results