Option

Description

Welcome

The utility opens with the Welcome page, which explains the purpose of the utility.

Click Next button to proceed to the next page of options or click Cancel to close the utility.

Settings

The Settings page allows you to change global catalog settings that determine when NULLs are returned for certain valid data.

·    Note  The following two global data source attributes may also be configured on the Data Source page of the Options dialog box.

-  The Invalid Numerics Return NULL option indicates that the Relativity DBMS will return a NULL value for any column based on a data item containing invalid numeric data.

-  The Invalid Dates Return NULL option indicates that the Relativity DBMS will return a NULL value for any date or date/time column based on a data item containing invalid date ranges either because the underlying numeric data is invalid, or the month or day is out of range.

Click the down arrow in either list box to change the three possible states for these options:

-  Select Never to cause the DBMS to return an error when this condition is encountered.  (This is the default.)

-  Select Yes, Except for Record Key Data Items to cause the DBMS to correct the condition for all data items except for record keys, which will still return an error.

-  Select Always to cause the DBMS to correct the condition in all instances.

Note  Selecting the Always state will result in some numeric data items not being available to participate in SQL indexes.

·    To specify whether settings are to be previewed or applied, choose from the following:

-  Report Only, to view a report containing only the results of changing these settings.

-  Apply Settings, to apply the settings without viewing a report.

-  Report First, then optionally apply, to view a report and then (optionally) apply the settings.

·    Select all the tables or a group of tables in the data source to process with either the Process All Tables or Select Tables to Process options.

Note  If you choose the Select Tables to Process option, the Table Selection page is displayed, prompting you to select the appropriate tables.  Make your selection(s) and click Next.

·    Click Cancel to close the utility, click Back to return to the previous page, or click Next to open the Options page.

Options

The Options page allows you to select which columns are to be included in an index:

·    Only columns that do not participate in an index.  Indicates a sorted index.  Relativity supports only Clustered indexes.

·    All columns.  Indicates an index that can be used to directly index to a row in the table, but is not otherwise sorted.

CAUTION  You may lose indexes depending on your settings for the Invalid Numerics Return NULL and the Invalid Dates Return NULL options on the Settings page.

·    Click Cancel to close the utility, click Back to return to the previous page, or click Next to open the Summary page.

For more information on indexes, refer to "Relativity Indexes" under the For Advanced Users | Relativity-Specific topic in the DBMS Help file.

Summary

A list of all the options you selected is displayed on the Summary page.

Click Finish to start the process.  A Status Report window opens and displays actions taken, and also explains why some actions were not taken.

Note  If on the Settings page you chose to apply the settings rather than simply review a report, you will be prompted with a message to confirm whether you want to update the data source with these changes.