Table functions return columns of a table and resemble
a table created through a CREATE TABLE statement.
A table function can be used only in the FROM clause of
an SQL statement. Table functions can be qualified with a schema name.
MQREADALL
The MQREADALL function returns a table that contains the
messages and message metadata from a specified MQSeries® location with a VARCHAR column
without removing the messages from the queue.
MQREADALLCLOB
The MQREADALLCLOB function returns a table that contains
the messages and message metadata from a specified MQSeries location with a CLOB column without
removing the messages from the queue.
MQRECEIVEALL
The MQRECEIVEALL function returns a table that contains
the messages and message metadata from a specified MQSeries location with a VARCHAR column
with removal of the messages from the queue.
MQRECEIVEALLCLOB
The MQRECEIVEALLCLOB function returns a table that contains
the messages and message metadata from a specified MQSeries location with a CLOB column with
removal of the messages from the queue.