contact contact

B.08.20 / Release Notes / Database / dbftswords

dbftswords utility

  The dbftswords utility may be used to list FTS keywords for a specific FTS field. Typical use includes verifying the FTS keywords match expectations or to create a keyword exclusion list.
dbftswords [options] database set field [filter [limit]]

 -help   - show usage (this list)
 -u user - set user name
 -p pswd - set password
 -d flgs - debug flags
 -1      - list keyword only
Where database specifies the database, set specifies a data set and field specifies the FTS field.

A search expression, partial word or range may be specified as filter to only list matching keywords. If not present, all keywords will be listed.

A limit may be specified to reduce the output to keywords with at least that many occurrences.

By default, the keyword along with the number of references is output.

$ dbftswords sample customers name KEL@
# 1 keyword qualified (3 references)
The option -1 (one) may be used to omit the reference count so the output may be used as an exclusion list (in dbutil).
$ dbftswords -1 sample customers name KUNST@ 5

  Privacy | Webmaster | Terms of use | Impressum Revision:  2012-11-07  
  Copyright © 2012 Marxmeier Software AG