The list of messages waiting to be handled by a subscriber listening to a topic. Each row in this table represents a single message for a subscriber.
Column | Data Type | Constraint |
---|---|---|
| NUMERIC(19) | NOT NULL |
The subscriber ID of the subscriber receiving the message. | ||
| numeric(19) | NOT NULL |
The unique identifier of the message used internally by the SQL-JMS system. | ||
| NUMERIC(19) | NULL |
A Java long date value that specifies when the message should be delivered. The value is a date/time in the form of UTC milliseconds from the epoch start (1 January 1970 0:00 UTC). If there is to be no delayed delivery of the message, this column effectively holds a timestamp of when the message was put into the queue allowing it to be delivered as soon as possible. | ||
| NUMERIC(19) | NULL |
The current state of the message. A message that is not currently being handled by a client has a value of zero. A message that is being handled has a non-zero value. Messages that are handled successfully are deleted from this table. |