Hitachi

Hitachi Advanced Database Messages


KFAA30312-E

The total size of aa....aa exceeds 2 GB. (M+J+O)

The total length of aa....aa exceeds 2 GB. <SQLSTATE: 56001>

aa....aa: Cause
  • dynamic parameters: The total value of data lengths specified in the dynamic parameters exceeds 2 GB.

  • search results: The total value of data lengths in the search results exceeds 2 GB.

S:

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

Action:

Correct the SQL statement using one of the following methods:

  • If aa....aa is dynamic parameters

    Reduce the number of dynamic parameters in the SQL statement.

  • If aa....aa is search results

    Reduce the search result column count in the SQL statement. If the number of batch-transmission rows when FETCH processing is performed is specified with the client definition's adb_clt_fetch_size operand, reduce the specified value of the adb_clt_fetch_size operand.