Deleting an Array

Go Up to Accessing Array Data

There are three ways to delete an array:

1. Delete the row containing the array. You can use DSQL to execute a DELETE statement.

2. Replace the array with a different one, as described above. If an array column contains an array ID, and you modify the column to refer to a different array, the array referenced by the previously stored array ID will be deleted during the next garbage collection.

3. Reset to NULL the column referring to the array. For example, use DSQL to execute a statement like the following, where ­LANGUAGE_REQ is an array column:

"UPDATE JOB SET LANGUAGE_REQ = NULL
WHERE JOB_CODE = "SA12" AND JOB_GRADE = 10"

The array referenced by the previously stored array ID will be deleted during the next garbage collection.