When you start a stored SQL statement, ISQL moves it to the command buffer and then processes it. Start the statement stored as DEPT by typing the following:
start dept
When the results appear on your display, verify that the FORMAT commands you typed with the SELECT statement stored as DEPT are still in effect.
| Note: | Only the SELECT portion of the stored statement is recalled. The stored formatting commands are not shown although you can see their effect on the query. |
Type END. The stored SELECT statement called DEPT is not erased. It remains in storage until you decide to erase it.