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 Processor— Figure 2.15

  Figure 2.15. DB2 Command Line Processor.

  

• Command Window— Figure 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 the two tools is that in the Command Window, every command has to be preceded by db2, as shown in Figure 2.16.