KFAA30808-E

The row length of the work table exceeds aa....aa bytes. <SQLSTATE: 40518>

aa....aa:

Maximum row length of the work table

S:

Invalidates this transaction.

Action:

Correct the SQL statement to reduce the columns of the work table so that the row length of the work table is aa....aa bytes or fewer. For details about columns of the work table, see Work tables created when SQL statements are executed in the HADB Application Development Guide.

If you cannot reduce the columns of the work table, you might be able to prevent this error by changing the page size of the work table DB area. To change the page size of the work table DB area, temporarily terminate the HADB server by using the adbstop command, and then change the value specified for the adb_dbarea_wrk_page_size operand in the server definition. Then, execute the adbstart command to start the HADB server.

For details about the relationship between the page size of the work table DB area and the maximum row length of the work table, see Maximum row length of work table in Maximum and minimum values related to database in the HADB Setup and Operation Guide.