FTI_ADD function

Use this function to index all of the text in documents. Use an SQL string or Named Query to query the database and determine the documents to be indexed.

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 diagram
>>-fti_add--+-------------+--+----------------+----------------->
            '- -f--folder-'  '- -G--applGroup-'   

>-- -h--instance--+- -i--sqlQuery------+--+---------------+----->
                  +- -q--namedQuery----+  '- -l--holdname-'   
                  +- -t--search_string-+                      
                  '- -T--search_string-'                      

>--+---------------------------------------+--+-------------+--->
   '- -S--startdate,enddate--+-----------+-'  '- -p--passwd-'   
                             '-,--format-'                      

>--+-------------+--+-----------------+--+-----+---------------->
   '- -u--userid-'  '- -U--user_alias-'  '- -v-'   

>--+-------------+--+-----------------------------+------------><
   '- -X--loadId-'  '- -1--trace_file-- -2--level-'   
When you use the parameter file option, you must specify the -F, -h, -p, -u, -U and -v 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--+-------------+------->
                                          '- -p--passwd-'   

>--+-------------+--+-----------------+--+-----+---------------->
   '- -u--userid-'  '- -U--user_alias-'  '- -v-'   

>--+-----------------------------+-----------------------------><
   '- -1--trace_file-- -2--level-'   
The syntax of the parameter file for the fti_add function is: 
Read syntax diagramSkip visual syntax diagram
>>-[-- -f--folder--]--+----------------------+------------------>
                      '-[-- -G--applGroup--]-'   

>--+-[-- -i--sqlQuery--]---+------------------------------------>
   '-[-- -q--namedQuery--]-'   

>--+---------------------------------------------+-------------><
   '-[-- -S--startdate,enddate--+-----------+--]-'   
                                '-,--format-'