Close frees the resources associated with statement. This happens automatically when statement is garbage collected; however, you can call Close to release the resources immediately.

Any descendant modules of statement are closed when statement is closed.  (A module is a descendant of a parent module if it is returned by one of the parent module's exports or if it is a descendant of one of the parent module's descendants.)

$\mathrm{driver}≔\mathrm{Database}\left[\mathrm{LoadDriver}\right]\left(\right)\:$

$\mathrm{conn}≔\mathrm{driver}:-\mathrm{OpenConnection}\left(\mathrm{url}\,\mathrm{name}\,\mathrm{pass}\right)\:$$\mathrm{stat}≔\mathrm{conn}:-\mathrm{CreateStatement}\left(\right)\:$

$\mathrm{res}≔\mathrm{stat}:-\mathrm{Execute}\left(''SELECT\; *\; FROM\; animals''\right)\:$

$\mathrm{stat}:-\mathrm{Close}\left(\right)$

$\mathrm{res}≔\mathrm{stat}:-\mathrm{Execute}\left(''SELECT\; *\; FROM\; animals''\right)\:$

$\mathrm{res}:-\mathrm{Next}\left(\right)$