DB2 Server for VSE & VM: Interactive SQL Guide and Reference

Reusing the Current SQL Statement

Before the system processes an SQL statement, it inserts it into a special storage area called the SQL command buffer. Once in the buffer, the statement becomes the current statement until it is pushed down in the queue by the next statement. ISQL commands are also inserted into the command buffer when you type them in, but not when you invoke them by using a PF key.

Using the command buffer facility, you can rerun a typed statement by using the ISQL START command (PF12).

Process the current SQL statement by performing the following:

1. Type the statement:

      select * -
      from department
   

2. When the result is displayed, type the END command.
3. Reenter the SQL statement by typing:

      start
   

The START command becomes even more useful when you have a typing error in an SQL statement. The error can be corrected (described in the next topic) and the START command used to reenter the corrected statement.