Row Size, Key Size, and Key Location

These three integers indicate the length of the table row and the location of the key within the row. Table 195 shows the minimum value, maximum value, and default value for Row Size, Key Size, and Key Location.

Table 195. Sizes

Field Name

Minimum Value

Maximum Value

Default Value

ROW SIZE

1

32767

1

KEY SIZE

1

smaller of 256 or ROW SIZE

1

KEY LOCATION

1

ROW SIZE – KEY SIZE + 1

1

If the View has been previously defined, tablesONLINE will fill in the values for these fields. If the View has not been defined, these values have to be calculated.