Fulltext Designer

The fulltext designer serves three purposes:

Create a basic definition of a fulltext systems for automatic or manual indexing.
Create or delete internal fulltext triggers (description can be found on the CREATE FULLTEXT command).
Rebuild the fulltext index.

You must specify the following parameters when creating a new fulltext system (these parameters cannot be changed later):

Name: Object name, unique in a schema.
Language: Language of the fulltext system.
Convert words to basic form: Corresponds with the LEMMATIZED flag in the CREATE FULLTEXT command.
Index documents inside an archive: Corresponds with the SUBSTRUCTURED flag.
Store the index in an external file: Corresponds with the SEPARATED flag (since version 9.5).
Document ID is BigInt: Corresponds with the BIGINT_ID flag (since version 10.0)

You can also create, modify and delete a fulltext system using the CREATE FULLTEXT, ALTER FULLTEXT and DROP FULLTEXT SQL statements.

The fulltext syntax can be checked at anytime using the Design / Validate action. The source code can be viewed using the Show SQL action.

Edit Activities

Insert a fulltext trigger	Fill the last row of the grid according to the description in the next paragraph.
Remove a fulltext trigger	Select one or more rows in the grid by clicking the row header and pressing the Delete button or the menu action Design / Delete selected row(s).
Modify a fulltext trigger	Modifying a saved row is not possible (only insert and update are supported).
Reindex	Select one of more grid rows and press the Reindex documents in the table(s) button.

Reindexing is done automatically when a fulltext trigger is inserted or removed (and changes are saved).

Grid column descriptions

Document table - Table from an open application whose column should be indexed.

Document ID column - A column (INT or BIGINT type) that serves as a unique document identifier. If the column fulfills the requirements of the fulltext system (INT or BIGINT type with an unique index and a DEFAULT value), it will be shown in the combo box. If the DEFAULT value of the column is different from the fulltext_sequence.NEXTVAL, a question mark will follow the column name. The application author must consider whether the method of assigning unique values is sufficient. If no suitable column is in the table, choose the Add new ID column action from the combo box and a new column of the INT type with the DEFAULT value fulltext_sequence.NEXTVAL will be inserted to the table or this DEFAULT value and unique index will be assigned to a certain column (INT or BIGINT type). The designer will not allow to assign one ID column to more document columns.

Document column(s) - Name of the column ((N)CHAR, (N)CLOB or BLOB type) that should be indexed.

Indirect - The method of document storage (not checked = document is stored directly in the column, checked = document is in an external file and the column only has the name).

Format - The document format. If not specified, the system will try to determine the format automatically. The list will be filled according to the fulltext plug-ins.

Related Objects

Together with the fulltext object related fulltext tables and sequences will be created. These objects will be deleted after deleting the fulltext object.

Sequence Designer

Database Objects Designers

XML Form Designer