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