Configuring a Subscriber Reply Sender

A subscriber endpoint can be configured to send the subscription status as a reply to the message sender if the message contains a reply subject. The ADB_SUBSCRIBER_STATUS AE schema is used for this reply message.

The following table lists and describes the columns in the ADB_SUBSCRIBER_STATUS AE schema:

Column Type Description
RETURN_CODE i4 Different values of the RETURN_CODE column are returned on the following conditions:
  • 0: when data is inserted into the destination table successfully.
  • -1: when the data is inserted into the exceptions table or opaque exceptions table.
  • 5: when the data fails to be inserted in both destination table and exceptions table (or opaque exceptions table).

    For example, if the data fails to be inserted into the destination table and you do not configure the exceptions table or opaque exceptions table, the value of the RETURN_CODE column is 5; if the data fails to be inserted into the exceptions table and you do not configure the opaque exceptions table, the value of the RETURN_CODE column is also 5.

If you specify a subscriber precommit stored procedure, this column contains the value of the RETURN_CODE output parameter.

Note: The RETURN_CODE column does not support bulk insert operations.
ADB_TEXT string Contains the status or error message of the subscriber operation.
Note: The ADB_TEXT column does not support bulk insert operations.
NUMBER_OF_UPDATED_ROW i4 Indicates the number of records that have been updated when you execute a SQL update statement. This column helps you track the current behavior of Subscription Service.
Note: The following situations affect the value of this column:
  • When Subscription Service receives a group message, the value of the NUMBER_OF_UPDATED_ROW column is the sum of the messages updated in the database.
  • When Subscription Service receives a parent-child message, the value of the NUMBER_OF_UPDATED_ROW column is the number of rows of the parent table that are updated in the database.
  • If a record is inserted into the exceptions table or opaque exceptions table, the value of the NUMBER_OF_UPDATED_ROW column is 0.
Note: The NUMBER_OF_UPDATED_ROW column does not support bulk insert operations.
CALLOUT_TEXT string Contains an error message from the database driver in case of an error operation.

If you specify a subscriber precommit stored procedure, this field contains the value of the SP_TEXT output parameter.

Note: The CALLOUT_TEXT column does not support bulk insert operations.