Book a Demo

Author Topic: Howto set "Not Null" in DDL Model  (Read 4292 times)

Daniel Sirz

  • EA Novice
  • *
  • Posts: 8
  • Karma: +0/-0
    • View Profile
Howto set "Not Null" in DDL Model
« on: April 10, 2009, 02:45:39 am »
Hello,

is it possible to set "Not Null" in the DDL during tranformation from PIM to PSM(DDL)?

Thanks a lot,

Daniel

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: Howto set "Not Null" in DDL Model
« Reply #1 on: April 20, 2009, 01:39:41 pm »
In the latest build of EA (844) this is done by the multiplicity of the connector.

allancstewart

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Howto set "Not Null" in DDL Model
« Reply #2 on: April 22, 2009, 11:16:44 pm »
Could you please expand on how to use the connector to ensure that PIM class attributes, not PK/FK fields, are transformed to the DDL as NOT NULL.

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: Howto set "Not Null" in DDL Model
« Reply #3 on: April 23, 2009, 09:07:23 am »
Sorry, I misunderstood, that was for foreign keys.

Just add "notnull" (without quotes) to your column block in the transform.

allancstewart

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Howto set "Not Null" in DDL Model
« Reply #4 on: April 23, 2009, 02:14:00 pm »
Excellent, thanks.  I knew it had to be something easy.