Datatypes in a PDM

Value placeholders, like Columns and Domains, have a "datatypes" assigned. This tells you something about the type of value this placeholder will accept and automatically restricts the possible values.

For example, is the datatype is set to "integer" a value of "ABC" cannot be accepted. On the other hand, if a datatype of "character" is used, both "ABC" and "123" are valid values.

In a PDM, the list of available datatypes differs per database system.

If you're using a datatype in a CDM that's not really available in the database system used for the PDM, eg a "money" datatype, Database Workbench will convert this to the nearest available datatype.