Managing Quotation Marks Around Values (PDM)

For a domain or a column, standard parameters can indicate minimum, maximum, and default values as well as a list of values.

In general, if the data type of domain or column is a string data type, quotation marks surround its values in the generated script. The generation of single or double quotation marks depends on the target DBMS.

However, quotation marks are not generated in the following cases:


In addition, if the value is already surrounded by quotation marks additional quotation marks are not generated.

The following table shows the way a value for a string data type is generated in a script:

Value for string data type

Result in script

Active

'Active'

'Active'

'Active'

"Active"

'"Active"'

~Active~

Active

NULL

NULL