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.