DELETE function

Use to delete index records that point to individual documents in Content Manager OnDemand. The data will still exist in cache or on archive media, because the documents being deleted might represent only a few pages of an entire input file. However, the data will no longer be retrievable after the index records are deleted.

To identify the documents for which you want to delete index records, you can use the following parameters to query the database:
  • SQL query (-i)
  • public named query (-q)
  • text search string (-t or -T)

If you use an SQL query, it must contain clauses, database field names, index values, and operators. The DELETE function deletes all database rows that match the query.

Read syntax diagramSkip visual syntax diagramarsdoc delete-ffolder-GapplGroup-hinstance -isqlQuery-qnamedQuery-tsearch_string-Tsearch_string-ppassword-Sstartdate,enddate,format-uuserid-Uuser_alias-v-1trace_file-2level
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 DELETE function when you use the parameter file option:
Read syntax diagramSkip visual syntax diagramarsdoc delete-Fparmfile -hinstance -ppassword-uuserid-Uuser_alias-v-1trace_file-2level
The syntax of the parameter file for the DELETE function is:
Read syntax diagramSkip visual syntax diagram[-ffolder ][-GapplGroup][-isqlQuery][-qnamedQuery][-tsearch_string][-Tsearch_string][-Sstartdate,enddate,format]