KFAA34002-E
There is an error in the specification method of a scalar function "CONTAINS" argument. (reason = aa....aa) (M+J+O)
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.
-