Hitachi

Hitachi Advanced Database Messages


KFAA31131-E

A delimited identifier which contains left parentheses or right parentheses can be specified only in the first query specification except for a WITH clause in the SELECT statement. (M+J+O)

A delimited identifier that contains left or right parentheses can be specified only in the first query specification in the SELECT statement. However, a delimited identifier that contains left or right parentheses cannot be specified for a query specification in the WITH clause. <SQLSTATE: 425CL>

S:

Ignores this SQL statement.

Action:

Correct the SQL statement.

Note that, for the following locations, single-byte left or right parentheses can be specified at the beginning of the name.

  • The column name of the "selection expression AS column name" within the first query specification, excluding query specifications within the WITH clause of the SELECT statement.

  • The column name in the "selection expression AS column name" within the first query specification of the COPY statement.

  • The column name in the ORDER BY clause (excluding ORDER BY clauses specified within subqueries).