BULK_DELETE function
To identify the documents that you want to delete, you can use the following parameters
to query the database:
- SQL query (-i)
- text search string (-T)
If you use an SQL query, it must contain clauses, database field names, index values, and operators. Without the -L parameter, the BULK_DELETE function deletes all of the documents that match the query. You can optionally use the -L parameter to specify a maximum number of rows to be deleted, regardless of the number of items that match the query. This method allows for the deletions to be done in smaller batches, in a more controlled manner, by running the same ARSDOC command multiple times.
When you use the parameter file option, you must specify the -F, -h, -p, -u, -U, -v, -1, and -2
parameters on the command line. All other parameters must be specified in the parameter file. The
following diagram shows the syntax of the BULK_DELETE function when you use the parameter file
option:
The syntax of the parameter file for the BULK_DELETE function is: