9.44 DELETE_IN_SPACE

Note: Built-In Function Rules     Usage Options

Deletes all cell rows that match the key values supplied.

Arguments

No Type Req/ Opt Description Min Len Max Len Min Dec Max Dec 1 A R Space Name 1 256     2-20 X O Fields specifying the key values to be used to locate the cell rows to be deleted.   1 Unlimited   Unlimited

Return Values

No Type Req/ Opt Description Min Len Max Len Min Dec Max Dec 1 A O Standard Return Code "OK" = A cell row was found and the cell values have been returned. "NR" = Now cell row could be found with a key matching the key values supplied. "ER" = Select attempt failed. Messages issued will indicate more about the cause of the failure.   2 2

Technical Notes

You can specify less key values than are defined in the space. All matching cell rows will be deleted. This means that partial keys operations can be performed. 

The operation USE DELETE_IN_SPACE (CustomerList) will delete all cell rows from the space named CustomerLists.

If you specify more key values than are defined as key cells for the space then the additional values will be ignored and have no effect on the outcome of the delete operation.

If a key value longer than 256 bytes is specified, a fatal error will occur.