Hitachi

Hitachi Advanced Database Setup and Operation Guide


11.16.4 Checking the information about synonym dictionaries

When you want to check a synonym dictionary name, or when you want to check whether a synonym dictionary supports correction search, search the system table.

Organization of this subsection

(1) Checking the information about a specific synonym dictionary

Example:

In this example, whether the synonym dictionary Dictionary1 supports correction search is checked.

SQL statement to be executed

SELECT * FROM "MASTER"."STATUS_SYNONYM_DICTIONARIES"
    WHERE "SYNONYM_DICTIONARY_NAME"='Dictionary1'

Execution result example

[Figure]

Explanation:

Because CORRECTIONRULE is displayed in the CORRECTION_RULE column, synonym dictionary Dictionary1 supports correction search.

If CASESENSITIVE is displayed in the CORRECTION_RULE column, the synonym dictionary does not support correction search.

For output items that do not have an explanation, see the explanation of the column information in STATUS_SYNONYM_DICTIONARIES in C.6 Content of STATUS_SYNONYM_DICTIONARIES.

The display format of the preceding search result is partially different from the display format of the actual output.

(2) Checking the information about all synonym dictionaries

Example:

In this example, the list of synonym dictionaries and information regarding individual synonym dictionaries are checked.

SQL statement to be executed

SELECT * FROM "MASTER"."STATUS_SYNONYM_DICTIONARIES"

Execution result example

[Figure]

For example, when you display the list of synonym dictionaries and check the synonym dictionary name you specify in the SQL statement, guess the applicable synonym dictionary from the comment.

The display format of the preceding search result is partially different from the display format of the actual output.