Syntax options:
ROW LENGTH IS n BYTES
Specifies the length of each row allocated to the row cache. Rows
are not cached if they are too large for the row cache. area. The
ROW LENGTH is an aligned longword rounded up to the next multiple
of 4 bytes.
The maximum row length in a row cache is 65535 bytes.
When the name of the cache matches the name of an existing
logical area, ADD CACHE will calculate ROW LENGTH from the size
of the table row, or the size of the index node (for SORTED
RANKED, or UNIQUE SORTED indices). This cache is known as a
logical area cache.