Queue Data Status Codes

Variables
const	OMQ::SQL_QS_Waiting = "W"
	Queue Status SQL Character Code: WAITING.
const	OMQ::SQL_QS_Received = "R"
	Queue Status SQL Character Code: RECEIVED.
const	OMQ::SQL_QS_Error = "E"
	Queue Status SQL Character Code: ERROR.
const	OMQ::SQL_QS_Used = "X"
	Queue Status SQL Character Code: USED.

Detailed Description

These are the possible values for an asynchronous queue data's status; this is the actual value that is stored in the DB

See also

Queue Data Status Descriptions for the corresponding description for each status code

OMQ::QSMap for a hash that can be used to map from descriptive status codes to Queue Data Status Codes

OMQ::SQLQSMap for a hash that can be used to map from SQL status codes to Queue Data Status Descriptions

Variable Documentation

SQL_QS_Error

const OMQ::SQL_QS_Error = "E"

Queue Status SQL Character Code: ERROR.

The equivalent descriptive status is OMQ::QS_Error

SQL_QS_Received

const OMQ::SQL_QS_Received = "R"

Queue Status SQL Character Code: RECEIVED.

The equivalent descriptive status is OMQ::QS_Received

SQL_QS_Used

const OMQ::SQL_QS_Used = "X"

Queue Status SQL Character Code: USED.

The equivalent descriptive status is OMQ::QS_Used

Note

this status is only used in Oracle databases where the queue rows are not deleted in order to preserve the integrity of the indexes on the QUEUE_DATA table

SQL_QS_Waiting

const OMQ::SQL_QS_Waiting = "W"

Queue Status SQL Character Code: WAITING.

The equivalent descriptive status is OMQ::QS_Waiting