Database Generating DLL with NOT NULL Constraints

Database Generating DLL with NOT NULL Constraints

  
Hello - we are using an extention (Pentaho Kettle) to load data directly into some OutSystems entity tables and found that some numeric data columns are generated with NOT NULL contraints, while others are not. We do not want the NOT NULL contraint. Any idea why the table has NOT NULL constrains on some, but not other columns of the same data type? All of the entity columns are set to Mandatory=false with no default value.

Thanks
Hello Dan,

The database constraints should only be created for Primary Key and Referenced Attributes. The mandatory property doesn't alctually create a constraint in the database, per information on the outsystems help.

Can you provide a sample espace and correspondent datamodel where you're finding the NOT NULL constraints?

Thanks

Cheers
Miguel,

We can get an espace to you but in the mean time is there a way to change the not null constraint and make it stick?

Thanks
Dan
Hi Dan,

Wihout knowing which attributes have the NOT NULL constraint I can't say.

Cheers