A stored SQL statement can be recalled to the command buffer to become the current SQL statement without being processed. You can do this to make changes to it and store it again, or to simply verify that it is the statement that you want to process next. For example, recall DEPT by typing:
recall dept
The recalled statement resembles:
SELECT DEPTNO,MGRNO FROM DEPARTMENT ORDER BY MGRNO
You can also use the RECALL command to display the current SQL statement, or to place the previous SQL statement in the command buffer at the top of the stack so that it becomes the current SQL statement. To recall the previous SQL statement, type:
recall previous
The statement that was current in the buffer becomes the new previous SQL statement.
To display the current SQL statement in the command buffer, type:
recall
or press PF5. The absence of a name on the RECALL command instructs ISQL to display the current SQL statement.