ij Commands and Errors Reference
Page 29 of 39

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.

Example

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>