cancel
Showing results for 
Search instead for 
Did you mean: 

Default value assigned on creation of Database

Solved
Contributor

Default value assigned on creation of Database

Hi,

 

Each time a database is created, from whatever location (in a diagram, just adding it on an app...), a link between the database and the Target DBMS is created automatically with value SQL Ainsi.

 

MetaAssociation automatically created: (DBMS Release/Base-de-données)

 

How can I stop this from happening? I have dig in Hopex Studio in multiple objects, but I have not found how to stop this default value from being created. (see image attached)

 

Thanks.

4 Replies
MEGA

Re: Default value assigned on creation of Database

Hello SBureau

 

This is the expected behavior

 

By default with MEGA Database, each object of the MetaClass 'Database' should have a property 'Target DBMS'

The version is implemented by a link to an object of the Metaclass 'DBMS Target'.

The default value is SQL ANSI/ISO 9075:1992.

This information is mandatory in various situation, for example to compute datatype of columns

 

If you with to change the value of property 'Target DBMS', you need to update it after creation

Jerome
Contributor

Re: Default value assigned on creation of Database

Ok, thanks for the information.

 

I've looked all around the place and could not find where these DBMS Versions can be edited (to add or remove elements from the list). Can you point me to the right place? 

MEGA

Re: Default value assigned on creation of Database

Contributor

Re: Default value assigned on creation of Database

Thanks, that is complex!

 

I created a new Metaclass to maintain only the database system name. I think it will be enough for us for now. That is why I wanted the link to Target DBMS not to be generated automatcally because it may be confusing with the new field I created.

 

I will see what else I can do to avoid confusion

 

I really appreciate your help! 

 

Simon