previous
next
Use the following procedure to change the SQL data type in the relational database. You can change the data type by selecting a mapping option for the DMS item. If your database is already cloned, making this type of change to the relational database requires recloning unless your relational database supports data type transformations.
While it's not recommended, you can directly change the properties of the relational database columns. For example, you can changing "varchar" to "var". If you modify the length of a column, make sure that the record does not exceed its maximum size.
In the pane, right-click a data source and choose . The Client Configurator opens.
In the pane, click the data set that contains data items you want to change.
Do one of the following:
Right-click a data item and click a data type (for example,
or
). From the toolbar, click
to show the change in the
pane.
In the pane, select a data item. Then, in the pane, click the value for and select an option from the drop-down menu.
Modify the length and scale values, as needed.
NOTE:If you change the data item from an int to a dec (or vice versa), you may have to save your changes before you can modify the length.
Click anywhere outside the field.
To undo your changes, right-click the modified item, and select .
In the toolbar, click
.