remove

Removes a previously prepared statement from gfxd.

Syntax

REMOVE Identifier

Description

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

Example

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

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