Row and Key Parameters

These parameters — row length, key length, key location — are used to allocate storage for rows and to locate keys within the rows (see Table 158). If you have defined your table using Option D – Define All in the Define Table and View menu, these numbers will be generated for you by tablesONLINE based on the information provided in previous screens.

Table 158. Row and Key Length Limits

Field Name

Minimum Value

Maximum Value

Default Value

Row Length

1

32,767 bytes

1

Key Length

1

Smaller of 256 or Row Size

1

Key Location   

1

Row Size – Key length+ 1

1

Warning:
Although you may enter your own data here, or alter the existing data, it is generally good practice to use the numbers generated by tablesONLINE.