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]]
options:
-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@
3 KELLER
# 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
KUNSTSTOFF
KUNSTSTOFFTE
KUNSTSTOFFVE
|