Using DB2
IBM's DB2 is a powerful high-end, multiplatform 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:
1. | Select QMF from the ISPF menu. |
2. | To create a new query, press F6 to access the QMF Query panel. |
3. | Enter the SQL statement and press F2 to execute it. The results will be displayed on the screen. |
4. | QMF also enables you to specify different formatting and output options. Press F9 to access the report form screen. |
Get Sams Teach Yourself SQL in 10 Minutes, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
