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

SQL Anywhere 10.0.1 » MobiLink - Server Administration » MobiLink Server System Tables

ml_qa_clients Next Page

ml_qa_delivery


This table is used only for QAnywhere applications.

Caution    

Do not alter this table.

ColumnDescription
msgidVARCHAR(128). Globally unique message identifier.
seqnoBIGINT. Used to give an ordering to the messages, which is necessary for true queuing.
addressVARCHAR(255). Address of the target recipient.
clientaddressVARCHAR(128). Client part of the address.
clientVARCHAR(128). Client targeted by current client state.
originatorVARCHAR(128). The name of the originating client.
priorityINTEGER. A number from 0 to 9. Messages with a higher priority number are delivered before messages with a lower priority. The default is 4.
expiresTIMESTAMP . Expiry time after which the message might not be delivered.
kindINTEGER. Indicates whether the message is binary (1) or text (2).
contentsizeBIGINT. The size of the message. For binary messages, this is the number of bytes. For text messages, this is the number of characters.
statusINTEGER. The status of the message. Can be 1 (pending), 10 (receiving), 30 (expired), 40 (cancelled), 50 (unreceivable), or 60 (received).
statustimeTIMESTAMP. The time this status was achieved. The time is local to the client achieving the state.
syncstatusINTEGER. Indicates the state of the synchronization between the client and server with respect to this message. Can be 0 (not in sync), 1 (in sync), 2 (message should not be synchronized), or 3 (synchronizing).
receiveridVARCHAR(128). An identifier set by the receiver that identifies the receiver of the message, if any.