UPDATE function

Use to update documents. You must name the application group to update and specify one or more application group fields and their values. To identify the documents that you want to update, you can use the following parameters to query the database:
  • SQL query (-i)
  • hold name (-l)
  • public named query (-q)
  • text search string (-t or -T)
  • load ID (-x or -X)

If you use an SQL query, it must contain clauses, database field names, index values, and operators. The UPDATE function updates all of the rows that match the query. It does not change the actual document data.

Read syntax diagramSkip visual syntax diagramarsdoc update-ffolder-gapplGroup-GapplGroup-hinstance -isqlQuery-lholdname-qnamedQuery-tsearch_string-Tsearch_string-xloadID-XloadID-ndbfield=value-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 shows the syntax of the UPDATE function when you use the parameter file option:
Read syntax diagramSkip visual syntax diagramarsdoc update-Fparm_file -hinstance -ppassword-uuserid-Uuser_alias-v-1trace_file-2level
The syntax of the parameter file for the UPDATE function is:
Read syntax diagramSkip visual syntax diagram[-ffolder ][-gapplGroup-GapplGroup][-isqlQuery][-lholdname][-qnamedQuery][-tsearch_string][-Tsearch_string][-xloadID][-XloadID][-ndbfield=value][-Sstartdate,enddate,format]