FTI_RELEASE function

Use to release documents from being indexed. You can query the database by using an SQL string or Named Query to determine the documents that should be removed from being indexed.

Ensure that Full Text Index is turned on for the application group and you have permission to release documents from being indexed before you attempt this function. Otherwise, a permission error occurs.

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


>>-fti_release--+-------------+--+----------------+------------->
                '- -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_release function when you use the parameter file option:


>>-fti_release-- -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_release function is:


>>-[-- -f--folder--]--+----------------------+------------------>
                      '-[-- -G--applGroup--]-'   

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

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