Hitachi

Hitachi Advanced Database Messages


KFAA31301-E

The aa....aa is incorrectly specified. (reason = bb....bb) (M+J+O)

The specified LIMIT clause or window frame border is invalid.

  • A value specified in the window frame value specification for a window frame border is invalid. <SQLSTATE: 22013>

  • The value specified for row-count or offset in the LIMIT clause is invalid. <SQLSTATE: 22510>

  • The data type of row-count or offset in the LIMIT clause is invalid. <SQLSTATE: 429D9>

aa....aa: Invalid specification
  • limit row count: The maximum number of rows to return (row-count) as specified in the LIMIT clause

  • offset row count: The offset of the first row to return (offset) as specified in the LIMIT clause

  • window frame bound: Window frame border

bb....bb: Cause of the error
  • value: The specified value is invalid.

  • data type: The specified data type is invalid.

S:

Ignores this SQL statement.

Action:

Correct the SQL statement.