Product Documentation

V11.5 Update Guide

Previous Topic

Next Topic

Considerations

Items to be aware of when using Hot Alter Table:

  1. It is not possible to perform a hot alter on a keyed field. If a field is part of an index, then it cannot be manipulated through Hot Alter Table.
  2. It is presently only possible to change the data type for a string that has a length count, and it can be changed to another string data type that supports a larger length count.

    DETAILS: Hot Alter Table supports changing a string field type that uses a 1-byte or 2-byte length count to the same string field type with a larger length count or with no length count. That is:

    CT_FPSTRING can be changed to CT_F2STRING, CT_F4STRING, or CT_FSTRING.

    CT_F2STRING can be changed to CT_F4STRING or CT_FSTRING.

    CT_PSTRING can be changed to CT_2STRING, CT_4STRING, or CT_STRING.

    CT_2STRING can be changed to CT_4STRING or CT_STRING.

    CT_F2UNICODE can be changed to CT_FUNICODE.

FairCom R&D is researching options to relax these two dependencies in the future. If you are impacted by these limitations, please notify the FairCom Support Team.

TOCIndex