FREE LOCATOR statement (Invalidate locator)

Scalable Database Server, HiRDB Version 8 SQL Reference

Function

Deletes the link between a locator and the data allocated to it, and nullifies the locator.

Privileges

None.

Format

 
FREE LOCATOR locator-reference [, locator-reference]...
locator-reference:: = : embedded-variable

Operands

Specifies the embedded variable for the locator to be nullified.

Common rule

Specifying an embedded variable having the value for an invalid locator causes an error. If multiple embedded variables are specified, and those embedded variables include an embedded variable having the value of an invalid locator, an error occurs, and all valid locators are nullified.