You can change the data type of a field from integer to INT64. No dump and load of the field's data is required.

Note: To change a field's data type from INT64back tointeger, you must perform a dump and load of the field's data.

To change a field's data type from integer to INT64:

  1. Choose Schema > Field Editor. The Data Dictionary's Field Editor alphabetically lists all the tables defined for your database.
  2. Select the table that contains the field you want to modify. The Field Editor lists all the fields defined for the selected table.
  3. Choose Modify.
  4. Choose the field you want to modify. The Field Editor displays the field definition in the window. See Field Editor option for information about the fields on this window.
  5. Change the data type from integer to int64, and press GO. The Confirmation of data type change window appears:


  6. Select the Don't show me this again (for this session) option to stop confirmation messages regarding changing the data type from appearing for the rest of the session.
  7. Choose Yes to make the change, and then choose A to apply the changes.