remove

Removes a previously prepared statement from sqlf.

Syntax

REMOVE Identifier

Description

Removes a previously prepared statement from sqlf. The identifier is the name by which the statement was prepared. The statement is closed to release its database resources.

Example

sqlf(PEERCLIENT)> prepare listFirstTable as 'select * from firsttable'; sqlf(PEERCLIENT)> execute listFirstTable;
ID         |NAME
------------------------
20         |TWENTY
30         |THIRTY
10         |TEN

3 rows selected
sqlf(PEERCLIENT)> remove listFirstTable;
sqlf(PEERCLIENT)> execute listFirstTable;
SQLF ERROR: Unable to establish prepared statement LISTFIRSTTABLE