FTI_ADD function

Use this function to add documents to the full text index. To query the database to determine the documents to be indexed, you can use the following parameters:
  • SQL query (-i)
  • hold name (-l)
  • public named query (-q)
  • text search string (-t or -T)
  • load ID (-x or -X)

If a duplicate attempt is made to add the same documents to be indexed, no error occurs and ARSDOC displays a successful message. However, the system log might contain messages that indicate that the documents were already indexed.

Read syntax diagramSkip visual syntax diagramfti_add-ffolder-GapplGroup-hinstance -isqlQuery-lholdname-qnamedQuery-tsearch_string-Tsearch_string-xloadID-XloadID-Sstartdate,enddate,format-ppasswd-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 FTI_ADD function when you use the parameter file option:
Read syntax diagramSkip visual syntax diagram fti_add -F parmfile -h instance -ppasswd-uuserid-Uuser_alias-v-1trace_file-2level
The syntax of the parameter file for the FTI_ADD function is:
Read syntax diagramSkip visual syntax diagram [ -f folder ] [-GapplGroup][-isqlQuery][-lholdname][-qnamedQuery][-tsearch_string][-Tsearch_string][-xloadID][-XloadID][-Sstartdate,enddate,format]