O'Reilly logo

Sams Teach Yourself SQL in 10 Minutes by Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using DB2

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:

  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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required