HP 3000 Manuals HP 3000 Manuals
Removing LONG Column Data with a DELETE [WHERE CURRENT] Command
Syntax for the DELETE and DELETE WHERE CURRENT commands is unchanged for
use with LONG columns. It is limited for the DELETE command in that a
LONG column cannot be used in the WHERE clause.
In the following example, any rows in PartsTable with the PartName of
hammer are deleted.
DELETE FROM PartsTable WHERE PartName = 'hammer'
When LONG column data is deleted, the space it occupied in the
DBEnvironment is released when your transaction ends. But any data file
selected earlier still exists on the operating system. You may want to
design a "cleanup" strategy for such files that are no longer needed.