To create an IVF Text Index:

  1. Click the IVF Text Index object in the tree. The Properties page appears.

     

  2. Click Create. The Introduction window for the Create IVF Text Index Wizard is displayed.

  3. Click Next. The Name the IVF Text Index window is displayed.

  4. Select the name of the table from which the IVF text index is to be created from the Table Name menu.

  5. Enter the name of the text index in the IVF Text Index Name field.

  6. A list of available columns on the selected table appears on the left hand list box. Select the columns that you want to use in the IVF text index by double clicking on the column name or selecting the column and clicking the Add button. The Add all button can be used to add all columns to the index. All the columns selected for the creation of the text index will be displayed in the list box to the right. Columns in the text index can be likewise removed by double clicking on the column name or selecting the column and clicking the Remove button.

  7. Click Next. The Select Storage Path window will open

     

  8. Select a storage path for the IVF text index by selecting the check box in the row corresponding to the IVF text index path. The paths and logical names that appear correspond to those specified in the configuration file. If you have not yet specified a path for storing IVF text indexes, open the JConfiguration Tool and add a new IVF Text Index Storage Path on the User Files page.

  9. Click Next. The Total Text Size and Order by Column window will open.

  10. To change the total text size, enter a value into Total Text Size between 1 and 10,000.

  11. To present data as it relates to another column in the table select the Use order-by feature check box.

    1. Select the column that the IVF text index will follow the order of from the Order Column menu.

    2. Select the Ascending option button to order data in the IVF text index by the Order Column's ascending order.

    3. Select the Descending option button to order data in the IVF text index by the Order Column's descending order

  12. Click Next. The Final review window will open.

  13. To alter the SQL script, enter new script into the Create IVF Text Index SQL script field or click Previous to display the previous screens in the wizard.

  14. To complete the IVF text index creation after reviewing the SQL script, click Finish. The Information dialog box is displayed.

  15. Click OK.


Related topic:

Creating an IVF Text Index