Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

iSeries / AS400 FAQ : (Category) Programming : (Category) CL : How can I get started with QMQRY (Query Management Query)?

April 26, 2017AS400 category CL iSeries Management Programming QMQRY query STARTED

0

Posted

iSeries / AS400 FAQ : (Category) Programming : (Category) CL : How can I get started with QMQRY (Query Management Query)?

1 Answer

0

Posted

>>>>>>>>>> Query Management comes with OS/400. That is, you don’t have to license it separately. It is often confused with Query Manager, which works with Query Management and costs you extra money. Query Management (hereafter abbreviated QM) queries are built from two source members: a query definition, which is an SQL statement, and a report form. It’s not impossible to build these source members from scratch, but I don’t advise you to try to do so. You could probably handle the SQL statement, but trying to write the report format language would be challenging, to say the least! Instead, you can build these members from Query/400 queries. To begin, I assume you have a Query/400 query that you would like to run after prompting for record selection criteria. In this example, I call the query JOIN0B1. First, run the Analyze Query (ANZQRY) command against the query.