Change Database Field Type

It is sometimes necessary to change the type of fields used to manage an entity: For example: transitioning client code from numeric to alphanumeric.

You may also wish to harmonize the way an entity is stored. For example: an entity that is sometimes managed in P(3.0) and sometimes in S(5.0): we may wish to transition it to I(10.0).

THE SOLUTION

To do this, ARCAD-Transformer uses the following method: Assistance in developing the original list of database fields. Iteration propagation of the entity examined (See § ARCAD-Transformer - Field expansion). Automatic modification of the source code by:

• changing field declarations (type and/or length)
• shifting the following fields (in the structures)
• changing certain instruction codes ("Z-Add" becomes "Eval")
• removing editing keywords from DSPF/PRTF fields