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_delivery Next Page


This table is used only for QAnywhere applications.


Do not alter this table.

msgidVARCHAR(128). Globally unique message identifier.
seqnoBIGINT. Used to give a total ordering to the messages, this is necessary for true queuing.
addressVARCHAR(255). Address of the target recipient.
targetVARCHAR(128).Client targeted by the current state.
originatorVARCHAR(255). The name of the originating MobiLink user.
priorityINTEGER. A number from 0 to 9. Messages with a higher number are delivered before messages with a lower number. 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 (receivable), or 60 (received).
statustimeTIMESTAMP. The time this status was achieved. The time is local to the client achieving the state.
verbiageVARCHAR (32767). Localized description of the status (if any).
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), or 2 (message should not be synchronized).
receiveridVARCHAR(128). An identifier set by the receiver that identifies the receiver of the message, if any.

The owner of this table is ml_qa_user_group.