Hitachi

Hitachi Advanced Database Messages


KFAA34007-E

The synonym dictionary cannot be used by an HADB server in a multi-node configuration. (M)

A synonym search cannot be performed if the multi-node function is used. <SQLSTATE: 428T9>

S:

Ignores this SQL statement.

Action:

Correct the specification of the scalar function CONTAINS. The following shows a correction example.

Before change:

CONTAINS("DOC",'SYNONYM("TERM","PC")') > 0

After change:

CONTAINS("DOC",'"PC"') > 0 OR
CONTAINS("DOC",'"personal computer"' ) > 0 OR
CONTAINS("DOC",'"microcomputer"') > 0

As shown above, use the logical operator OR to specify all the synonyms to be searched for.