Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » MobiLink - Server Administration » MobiLink Reference » MobiLink server system tables

 

ml_qa_repository_staging

This table is used only for QAnywhere applications. It contains messages that are to be sent to a QAnywhere client using SQL Anywhere version 9.0.1.

Caution

Do not alter this table.

Column

Description

seqno

BIGINT. Used to give a total ordering to the messages, this is necessary for true queuing.
msgid

VARCHAR(255). Globally unique message identifier.

destination VARCHAR(128). The address of the message.
originator VARCHAR(128). The name of the originating MobiLink user.
status VARCHAR(128). The status of the message. Can be pending, receiving, received, unreceivable, expired, or cancelled. The default is pending.
statustime TIMESTAMP. The last time the status was changed.
expires TIMESTAMP. Expiry time after which the message are not delivered.
priority INTEGER. A number from 0 to 9. Messages with a higher number are always delivered before messages with a lower number. The default is 4.
props LONG BINARY. An encoding of the message properties.
kind INTEGER. Indicates whether the message is binary (1) or text (2).
content LONG BINARY. The content of the message. Text messages are encoded as UTF-8.
contentsize BIGINT. The size of the message. For binary messages, this is the number of bytes. For text messages, this is the number of characters.
mluser VARCHAR(128). The MobiLink user name that uniquely identifies a remote database.
Constraints

PRIMARY KEY( msgid )