In our code, we do a CREATE on a entity. One attribute is set for 3 permitted values, <space>, S and N. This is currently working correctly.
Now we want to add another permitted value (P) for that attribute. On the Toolset we managed to get it right but after generating and when our users started to test it gave an error saying it violates the permitted values set for that attribute. The code logic executes the "WHEN permitted value violation" section.
Release : 8.5
Component : CA Gen Workstation Toolset
The Oracle DDL generated for the attribute is the following.
<ATTRIBUTE_NAME> CHAR(1) NOT NULL
CHECK (<ATTRIBUTE_NAME> IN ('P', 'S', 'N', ' ')),
Before the change to the permitted values in the model, the database has CHECK (<ATTRIBUTE_NAME> IN ('S', 'N', ' ')),.
After adding the permitted value in the model, the physical database needs to be updated for the new permitted value, CHECK (<ATTRIBUTE_NAME> IN ('P', 'S', 'N', ' ')),.