This table contains the non-standard properties for messages currently in the SQL-JMS system. Each row represents one property for a single message. A single message with multiple non-standard properties has multiple rows in the table.
Column | Data Type | Constraint |
---|---|---|
| NUMERIC(19) | NOT NULL |
The message ID of the message with which the property is associated. | ||
| NUMERIC(1) | NULL |
The data type of the property represented as a number. | ||
| VARCHAR(250) | NOT NULL |
The name of the property used by the JMS client to identify it within the JMS message. | ||
| VARCHAR(250) | NULL |
The value of the property represented as a String. |