KFAA34002-E

The specified scalar function CONTAINS contains an error.

aa....aa: Cause of the error

• correction format: The notation-correction-search specification or simple-string specification is invalid. <SQLSTATE: 428T0>

• correction value: The specified search string is invalid. <SQLSTATE: 428T1>

• synonym format: The synonym-search specification is invalid. <SQLSTATE: 428TA>

• synonym value: The synonym dictionary name is invalid. <SQLSTATE: 428TB>

• word-context format: The word-context search specification is invalid. <SQLSTATE: 428TC>

S:

Ignores this SQL statement.

Action:

The possible errors are as follows.

■ If aa....aa is correction format:

• An invalid character string might be specified in the notation-correction-search specification. Check whether a character string other than IGNORECASE or SORTCODE is specified.

• The following errors might exist:

  - The simple-string specification in the notation-correction-search specification is not enclosed in parentheses (( and )).

  - Parentheses (( and )) are not paired correctly.

  - A character exists between ( and a simple-string specification.

  - A character exists between a simple-string specification and ).

• The specification format of the simple-string specification might be invalid. Make sure that a double quotation mark (") is specified at the beginning.

■ If aa....aa is correction value:

• Make sure that the simple-string specification ends with ".

■ If aa....aa is synonym format:

• An invalid character string might be specified in the synonym-search specification. Check whether a character string other than SYNONYM is specified.

• The following errors might exist:

  - The synonym-search specification does not contain parentheses (( and )).

  - Parentheses (( and )) are not paired correctly.

  - A character exists between ) and a simple-string specification.

  - A character exists between ) and a notation-correction-search specification.

• The specified synonym dictionary name might be invalid. Make sure that a double quotation mark (") is specified at the beginning. Also, check whether a character is specified between " at the end of the synonym dictionary name and a comma (,) .

■ If aa....aa is synonym value:

• Make sure that the specified synonym dictionary name ends with ".

• Check whether characters that cannot be used are specified in the synonym dictionary name.

• Make sure that the length of the synonym dictionary name does not exceed 120 bytes.

• Make sure that the synonym dictionary name is specified. Make sure that an empty string (0 bytes) is not specified.

■ If aa....aa is word-context format:

• The character string might be specified in the word-context search specification might be invalid. Make sure that a character string other than WORDCONTEXT or WORDCONTEXT_PREFIX is not specified.

• Make sure that a synonym-search specification is not contained in WORDCONTEXT_PREFIX specified in the word-context search specification.

• Make sure that the word-context search specification contains parentheses (( and )).

• Make sure that the parentheses (( and )) in the word-context search specification are paired correctly.

• Make sure that no character exists between ) and a simple-string specification.

• Make sure that no character exists between ) and a notation-correction-search specification.

• Make sure that no character exists between ) and a synonym-search specification.