SELECT and Queue Tables
A queue table is similar to an ordinary base table, with the additional unique property of being similar to an asynchronous first-in-first-out (FIFO) queue.
The first column of a queue table always contains Queue Insertion TimeStamp (QITS) values. The QITS value of a row indicates the time the row was inserted into the queue table, unless a different, user-supplied value is inserted.
The CREATE TABLE statement for the table must define the first column with the following data type and attributes:
TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6)
You can use SELECT statements to perform a FIFO peek on a queue table. In this case, data is returned from the queue table without deleting any of its rows.
If no rows are available, no rows are returned. The transaction does not enter a delay state.
To return the queue in FIFO order, specify the first column of the queue table in the ORDER BY clause of the SELECT statement.
To perform a FIFO pop on a queue table, use a SELECT AND CONSUME statement. For more information, see “SELECT AND CONSUME” on page 37.
Note: A SELECT AND CONSUME statement cannot specify a scalar subquery.
For more information about how to define a queue table, see “CREATE TABLE (Queue Table Form)” in SQL Data Definition Language.