Schemas › M0 Schema › Functions › IS_HARDENED()

IS_HARDENED()

This function evaluates to a single character and is applied to columns that contain property values that can be hardened.

Note: CA ERwin DM r8 only allows hardening of name values, so this function only has meaning when applied to the NAME column and the PHYSICAL_NAME column of the ATTRIBUTE, DEFAULT, DOMAIN, ENTITY, KEY_GROUP, RELATIONSHIP, and VALIDATION_RULE tables. Future releases of CA ERwin DM may extend hardening to more property types.

It will evaluate to T if the value in the property has been hardened, otherwise, it will evaluate to F.

For example, suppose you use the Name Hardening Wizard to harden the Physical_Name of all Attribute objects in the eMovies.ERWIN model. The following query shows the results of the IS_HARDENED() function.

Note: The row restriction is to filter out view columns, which are not type-split from table columns as of CA ERwin DM r8.

Example: IS_HARDENED() function applied to objects