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 | Description |
---|---|---|---|
| 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. |