Previous Topic

Next Topic

Book Contents

Book Index

ECSA required for a single variable

The amount of ECSA required to store a single atomic variable is 16 bytes of control information, plus the number of characters in the variable column name, plus the number of characters in the value of the variable in that column.

For example, if a variable in the MYCOL column name has 7 characters in its value, that variable will require a total of 28 bytes of ECSA. This total is computed, for purposes of this example, by adding the 16 bytes required for control information, to the 5 characters in the length of MYCOL column name string, plus the number of characters in the value of the variable in that column, which in this example is 7.

The total size of a single variable slot is limited to 256 characters. Therefore, 240 characters is the maximum that the variable name plus the variable value may occupy.

This calculation is the same for all the database types shown below:

Parent Topic

Calculating the amount of ECSA needed to store the variables.