9 44 DELETE_IN_SPACE

9.44 DELETE_IN_SPACE

Þ Note: Built-In Function Rules.

Deletes all cell rows that match the key values supplied.

For use with

LANSA for i YES Only available for RDMLX. Visual LANSA for Windows YES   Visual LANSA for Linux YES

 

Arguments

No Type Req/ Opt Description Min Len Max Len Min Dec Max Dec 1 A R Space Name 1 256     2-20 w 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.