>>-HOLD--sql_statement----------------------------------------->< |
HOLD is an ISQL command that prevents an SQL statement from being processed when it is typed. The SQL statement is placed in the SQL command buffer and remains there until it is replaced with another SQL statement. You can check the SQL statement for typing errors before it is processed by a START command. You can also type an SQL statement containing placeholders and substitute values for the placeholders when the statement is started using a START command.
The following example illustrates the use of a HOLD command to place an SQL statement in the command buffer without executing it:
hold select * from employee
The HOLD command can also be invoked by pressing PF9 (or PF21) prior to, during, or after typing. By pressing PF9 instead of ENTER, the SQL statement typed is placed in the SQL command buffer without being processed. The HOLD PF key does not store the command in the SQL command buffer; you must press ENTER after pressing HOLD PF. The default key for the HOLD function is PF9 (or PF21).