Skip to Content

ReservedDefault for Text Values Not Working as Expected

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 16, 2015 at 07:07 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2015 at 04:19 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded