To edit a data type mapping set, select Tools > Data Type Mappings > Maintain Data Type Mappings.
- Select the Mapping Set to be modified from the list in the Maintain Data Type Mapping Sets window and then click the Edit button.
Standard Data Type Mapping sets are not editable, they can only be viewed.
In the Data Type Mapping Set window, select the parameter you want to change from the Conversions pane. Use the scroll bar to see all the defined parameters.
Use the buttons on the right side of the Data Type Mapping Set window to add new conversion parameters, and edit, copy, or delete a selected parameter. These buttons are not available for standard mapping sets. Only user-defined mapping sets are editable.
To move a parameter up or down in the list, select it and then click the Move Up or Move Down button.
The order of the data type mapping conversion parameters is significant because when loading a table, the procedure checks the data type mappings from top to bottom and stops when a data type and its parameters are correctly matched. A blank parameter means that it will match to anything.
Click OK when you're done.
See previous sections for details on adding or copying a new data type mapping set.