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

msg_id

NUMERIC(19)

NOT NULL

The message ID of the message with which the property is associated.

data_type

NUMERIC(1)

NULL

The data type of the property represented as a number.

name

VARCHAR(250)

NOT NULL

The name of the property used by the JMS client to identify it within the JMS message.

value

VARCHAR(250)

NULL

The value of the property represented as a String.