IBM's DB2 is a powerful high-end, multi-platform DBMS. It comes with a whole suite of client tools that may be used to execute SQL statements. The instructions that follow use the Query Management Facility (or QMF) utility because it is one of the simplest and most versatile of the bundled applications:
Select QMF from the ISPF menu.
To create a new query, press F6 to access the QMF Query panel.
Enter the SQL statement and press F2 to execute it. The results will be displayed on the screen.
QMF also enables you to specify different formatting and output options. Press F9 to access the report form screen.