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

RECALL

>>-RECALL----+-----------------------+------------------------->< +-stored_statement_name-+ '-PREVIOUS--------------'

RECALL is an ISQL command that retrieves a stored SQL statement. The stored statement is inserted into the SQL command buffer and is shown in your display. You must enter the START command before the statement is started.

stored_statement_name

is the name of the stored SQL statement to be recalled.

PREVIOUS

specifies that the previous SQL statement (the one typed prior to the current SQL statement) is to be recalled. The current SQL statement is then saved with the name PREVIOUS.

Entering RECALL with no name specified, or pressing the appropriate PF key, displays the statement currently contained in the SQL command buffer. The RECALL command can be invoked by pressing PF5. You can assign the RECALL function to any PF key; the default is PF5 or PF17.