Non-GUI Tools

For the non-GUI programmers, DB2 features the following two Command Line Tools that basically allow the programmer to enter SQL statements from the command line:

  • Command Line ProcessorFigure 2.15

    Figure 2.15. DB2 Command Line Processor.

  • Command WindowFigure 2.16

    Figure 2.16. DB2 Command Window.

All the commands available from these tools can be displayed onscreen as follows:

  • From the Command Line Processor, type ? (question mark) and press <Enter>.

  • From the Command Window, type db2 ? and press <Enter>.

The main difference between ...

Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd 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.