Syntax

The following special syntax is for Database Administrators who handle problems while migrating database tables from an older release database to a newer release database. In some cases, there may be a CRC mismatch error (when dumping and loading data using BINARY DUMP/LOAD.).

ALTER TABLE table_name SET PRO_FIELD_INFO PRO_SCHEMA_REPAIR

Using the above statement for a particular table automatically repairs all the known schema errors in the table that are causing the CRC mismatch. If the error persists even after running this statement, report the problem to Progress Customer Support with the _Field system table information in the old and new databases.

Execution of the above statement sets _DB-lang to its default value (0) and updates the following data type names as shown below:

• TIMESTAMP to DATETIME
• LVARBINARY to BLOB
• LVARCHAR to CLOB

Executing the above statement also sets the case sensitivity value of the non-character type columns to 0.

Example

ALTER TABLE Customer SET PRO_FIELD_INFO PRO_SCHEMA_REPAIR;

In the above example, the Customer table belongs to an old database. When you execute the above statement, the inconsistent field information is corrected and the table is updated with the new CRC.