Remove

Syntax

REMOVE Identifier

Description

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

Examples

ij> prepare seeMenu as 'SELECT * FROM menu';
ij> execute seeMenu;
COURSE    |ITEM                |PRICE 
-----------------------------------------------
entree    |lamb chop           |14 
dessert   |creme brulee        |6
 
2 rows selected
ij> remove seeMenu;
ij> execute seeMenu;
IJ ERROR: Unable to establish prepared statement SEEMENU
ij>