602SQL Documentation Index  

Fulltext Designer

The fulltext designer serves three purposes:

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

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 triggerFill the last row of the grid according to the description in the next paragraph.
Remove a fulltext triggerSelect 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 triggerModifying a saved row is not possible (only insert and update are supported).
ReindexSelect 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.