ReservedDefault for Text Values Not Working as Expected

[former_member1144245]

I want to include standard text default values for a dimensional data model so that they can be selected from the drop down list rather than be typed over and over again.

Using PowerDesigner v15.2 and a customized version of the Teradata.xdb. The standard values are Unknown and Not Applicable. When I enter these values in the ReservedDefault section of the Keywords Category of the .xdb, they appear in the drop down list as expected. However, the DDL that is generated does not put the quotes around the values.

Documentation states that "If a reserved word is used as a default value, it will not be enquoted." Given that Unknown and Not Applicable are not reserved words, I am not able to determine the issue.

Any assistance will be much appreciated!

[marc_ledier · Accepted solution]

Hi Monique,

The ReservedDefault contains the list of special DBMS variables that can be used as default values in columns.

Being variable, it is not intended to be enquoted.

But I tried it and you can add quotes directly in the ReservedDefault list. This does it.

Regards,

Marc

[former_member1144245]

Thanks Marc! I was hoping for a different way so that it would be consistent with other text default values that are manually entered when you look at the data model, but yes, it does work.