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

Erasing a Stored Statement

When you no longer need a stored SQL statement, you can erase it. Type: 

   erase olddept
The stored statement called OLDDEPT has been erased.

You can erase several stored statements with a single ERASE command: 

   erase first second



 

EXERCISE 5 (Answers are in Appendix A, Answers to the Exercises, page ***.)



  1. Recall the stored query MYQUERY.
  2. Change the query so that information is retrieved for salaries between
    $25000 and $30000, and is ordered by the employee's first name.
  3. Start the query.
  4. Exclude the middle initial from the result.
  5. Separate all columns with a blank, a vertical bar, an asterisk, a vertical
    bar, and a blank.
  6. Change the EDLEVEL column heading to SCHOOL YEARS.
  7. End the display and store the command along with all its formatting
    information using the name EXER11.
  8. List all the stored SQL statements.
  9. Retrieve the help information for the ISQL STORE command.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]