Hitachi

Hitachi Advanced Database Messages


KFAA30104-E

There is an unnecessary part "aa....aa" in the SQL statement. (M+J+O)

The SQL statement contains an error such as one of the following:

  • A name contains a character that cannot be specified. (such as a character encoding mismatch) <SQLSTATE: 42510>

  • A name with a length of 0 exists. <SQLSTATE: 42510>

  • The statement contains a character or keyword not allowed by the syntax. <SQLSTATE: 42510>

  • The first keyword of the SQL statement is invalid. <SQLSTATE: 42530>

  • The only character is a separator character. <SQLSTATE: 42530>

  • An extra character string exists after the SQL statement. <SQLSTATE: 42601>

aa....aa: The part of the SQL statement that contains the error.

If there is a character that cannot be specified under the rules, that character and its hexadecimal display are shown in parentheses.

  • If the part containing the error cannot be displayed as characters, a question mark (?) is displayed.

  • If an SQL statement contains only a separator character, a single-byte space is displayed.

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

If all the following conditions are satisfied, the system might determine that the name contains a character that cannot be specified.

  • A double-byte character is specified in the SQL statement.

  • The character encoding of the SQL statement does not match that of the HADB server.

In this case, make sure that the character encoding of the SQL statement matches that of the HADB server.

Action:

Correct the SQL statement.