Real Time Information Director User Documentation

ManualsBrandsHP ManualsServerHP NonStop G-Series

257

258

259

260

261

262

263

264

265

266

RTID Subscriptions

Hewlett-Packard Company 14 529618 - 002

<xs:element name="SQLstmt" type="xs:string"/>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:schema>

Table 4 lists and defines the XML tags used in this schema.

Tag Name Description

Subscriptions Root element of the XML document.

SubInfo Used to describe a Subscription.

DocName Specifies the name of the document that is to be generated.

DestQueueName Specifies the name of a JMS Queue into which documents for this

subscription will be posted.

DestTopicName Specifies the name of a JMS Topic into which documents for this

subscription will be posted.

SQLstmt Specifies the SQL statement that be used as the database trigger for

this subscription.

Table 4. SubServ.xsd – Tag Descriptions

Considerations for the SELECT statement

The Select statement is used to trigger an event caused by a change in the Data Store.

Typically, a subscription is triggered by the insertion of a new document into the Data

Store.

To support this function, the Subscription module uses the NonStop SQL/MX

Publish/Subscribe interface. For example, in the context of RTSC, every IDoc has a

related master table to which the Subscription module subscribes. A change to the master

table triggers a subscription, so whenever an IDoc is inserted into the Data Store, all

subscriptions that have selected the corresponding master table are triggered. The SQL

statement used to register a subscription must take into account the relationship between

the document being inserted and the master table that corresponds to this IDoc.

The SQL SELECT statement should select the key fields required for the Document

subscribed. Check the document definition of the subscribed document to get a list of the

required input fields for querying that document definition. For example, to subscribe to a

sales order, the SELECT should include the SALES_ORGANIZATION_CD,

SALES_ORDER_NO and SOURCE_NM the key fields of the SALES_ORDER table.