Getting to message queue data faster

Prior to the latest round of Technology Refreshes for 7.4 and 7.3 if I wanted to get the data from a particular message queue I would need to use the MESSAGE_QUEUE_INFO SQL View. Being a View it contains all the data from all of the message queues, not just the one I would be interested. If I wanted to retrieve the messages from one message queue it would take a while for the results to be found and returned.

There is now a MESSAGE_QUEUE_INFO Table function. Table functions are faster than Views as they are sort of like an API, I pass the message queue name to the Table function and only that message queue is searched for the information I want.

The results returned by the View and Table function are almost identical. The only difference is that the View returns columns for the name of the message queue and the library it resides. As I pass that information to the Table function it is irrelevant to its results.

MESSAGE_QUEUE_INFO Table function has four parameters:

Read more »

Drawing on decades of experience with #IBMi & #IBMPowerSystems, @Northdoorplc are getting together with some key IBM experts to bring you all the most important information & updates in our 2021 IBM i webinar.

Drawing on decades of experience with #IBMi & #IBMPowerSystems, @Northdoorplc are getting together with some key IBM experts to bring you all the most important information & updates in our 2021 IBM i webinar. northdoor.co.uk/join-our-ibm-i…
#IBMi pic.twitter.com/hQpvUjUEt1

– Northdoor plc (@Northdoorplc)02:42 – Jun 15, 2021

Automating documents saves time, so you can focus on the job at hand rather than pushing paperwork and struggling to find information. inFORM Decisions knows how important it is to be accurate and detailed in your forms and documents. 800-858-5544; #ibmi

Automating documents saves time, so you can focus on the job at hand rather than pushing paperwork and struggling to find information. inFORM Decisions knows how important it is to be accurate and detailed in your forms and documents.

800-858-5544; informdecisions.com/products/docum… #ibmi pic.twitter.com/5q3XCLLaaG

– inFORM Decisions (@inFORMDecisions)02:10 – Jun 15, 2021