O'Reilly logo

Discovering SQL: A Hands-On Guide for Beginners by Alex Kriegel

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

IBM DB2 9.7 EXPRESS-C

IBM DB2 provides three different utilities to access its database server: the interactive command line processor (CLP), the commanA-line db2 utility, and the graphical user application Command Editor. Here we will discuss the latter two.

IBM Command Editor

  1. Once the database server is up and running, launch the application from the IBM DB2 images Command Line Tools images Command Editor menu option. It takes some time for the application to start up. Figure A-15 shows the Command Editor GUI console with some SQL code already loaded.

    images

    FIGURE A-15

  2. Open the DiscoveringSQL.DB2.UDB.Library.sql file by clicking the Open Folder icon on the toolbar and navigating to the file's location. Once the file is loaded into the pane, click the Execute button (a green triangle icon on the toolbar). Figure A-16 shows the results of the execution: The Library database and all database objects are created. The process might take up to several minutes, depending upon your computer's characteristics.

    images

    FIGURE A-16

  3. Once the Library database and its objects are created, connect to the Library database ...

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