Topic
  • 6 replies
  • Latest Post - ‏2013-02-26T18:49:52Z by hskolwal
MarkOrmos
MarkOrmos
20 Posts

Pinned topic Domain Model (.ddm) data types

‏2013-02-19T11:40:50Z |
Hi,

I´m using a Domain Model (.ddm) to define domains for some columns in a physical data model (.dbm).
However the Domain model does not support some datatypes (especially i am missing GRAPHIC and VARGRAPHIC datatypes), which are standard in the physical data model.
Is there a way to extend the list of 'Base Type' in the domain model?

Thank you for your help!
Best regards
Mark
Updated on 2013-02-26T18:49:52Z at 2013-02-26T18:49:52Z by hskolwal
  • dtc
    dtc
    63 Posts

    Re: Domain Model (.ddm) data types

    ‏2013-02-19T17:12:02Z  
    The Domain Model enables you to define logical data types. Therefore, the base logical data types it supports are the same as those supported by the Logical Data Model. To define physical data types, you can use Distinct User-Define Type. The base physical data types it supports are the ones supported by the Physical Data Model, including GRAPHIC and VARGRAPHIC.
  • MarkOrmos
    MarkOrmos
    20 Posts

    Re: Domain Model (.ddm) data types

    ‏2013-02-26T08:54:38Z  
    • dtc
    • ‏2013-02-19T17:12:02Z
    The Domain Model enables you to define logical data types. Therefore, the base logical data types it supports are the same as those supported by the Logical Data Model. To define physical data types, you can use Distinct User-Define Type. The base physical data types it supports are the ones supported by the Physical Data Model, including GRAPHIC and VARGRAPHIC.
    I can create a Distinct User-Define Type in the physical data model, but how do I create it in the Domain model?

    Thanks for the answer!
    Best regards
    Mark
  • nmullin
    nmullin
    50 Posts

    Re: Domain Model (.ddm) data types

    ‏2013-02-26T14:52:41Z  
    • MarkOrmos
    • ‏2013-02-26T08:54:38Z
    I can create a Distinct User-Define Type in the physical data model, but how do I create it in the Domain model?

    Thanks for the answer!
    Best regards
    Mark
    Mark,

    Did you try the general tab of the Domain properties view? There is an option 'Transform as', which by default is 'none'. There are two other options: Distinct type and structured type. Perhaps the 'Transform as' is the option that you were looking for.

    I included a snapshot of the 'general' tab.

    hth
  • MarkOrmos
    MarkOrmos
    20 Posts

    Re: Domain Model (.ddm) data types

    ‏2013-02-26T15:38:49Z  
    • nmullin
    • ‏2013-02-26T14:52:41Z
    Mark,

    Did you try the general tab of the Domain properties view? There is an option 'Transform as', which by default is 'none'. There are two other options: Distinct type and structured type. Perhaps the 'Transform as' is the option that you were looking for.

    I included a snapshot of the 'general' tab.

    hth
    Thanks nmullin, I tried that now, but I still can't select the GRAPHIC or VARGRAPHIC datatypes from the Basetype list (see the screenshot in my first post). My goal is to define a domain with one of these datatypes. Is there probably another way to do it?

    Thanks for your answer!
    Best regards
    Mark
  • nmullin
    nmullin
    50 Posts

    Re: Domain Model (.ddm) data types

    ‏2013-02-26T18:02:40Z  
    • MarkOrmos
    • ‏2013-02-26T15:38:49Z
    Thanks nmullin, I tried that now, but I still can't select the GRAPHIC or VARGRAPHIC datatypes from the Basetype list (see the screenshot in my first post). My goal is to define a domain with one of these datatypes. Is there probably another way to do it?

    Thanks for your answer!
    Best regards
    Mark
    Mark,

    like dtc mentioned, the Domain Model enables you to define logical data types. Therefore, the base logical data types are the same as those supported by the Logical Data Model. To my knowledge you cannot change the base logical data types. You can always request an enhancement to IDA to include vargraphic and graphic as a logical data model data types.

    As a workaroud, I believe changing the logical to physical data model data type map (transform-->data type map-->logical to physical (select your database of choice) may accomplish what you are looking for. Of course, you want to ensure you change those physical data types that are NOT used as data types in your organization and you select your target database.

    This is accomplished in the preferences and should NOT be treated lightly as it is used during transformation.
  • hskolwal
    hskolwal
    11 Posts

    Re: Domain Model (.ddm) data types

    ‏2013-02-26T18:49:52Z  
    To add, the NCHAR and NVARCHAR data types in LDM are the closest equivalents of the GRAPHIC and VARGRAPHIC in DB2 PDM. The default data type mapping can be adjusted by user as such.