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 ...

Get Discovering SQL: A Hands-On Guide for Beginners 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.

Start your free trial