The GTL code for defining a column check constraint is
alter table [%QUALIFIER%]%TABLE%
add [%R%?(][constraint %CONSTNAME% ]check (%.A:CONSTRAINT%)[%CheckDeferrable%? [.Z:[deferrable][%CheckInitiallyDeferred%? initially deferred: [%R%?initially immediate]]]:[%R%? not deferrable]][%R%?)]
Here's the location in the database definition:
ORA12C::Script\Objects\Column\AddColnChck
It doesn't mention Enable or Validate - these aren't properties of the Column. Youd could add them yourself, and amend the GTL code, or you could raise a case with SAP, as a feature of Oracle (if that is the DBMS) is not supported. They could sort it pretty fast, and issue a new database definition file.
I think what you're looking for is on the DBMS-specific tab in the properties of the Reference - e.g. the tab may be called Oracle
Hmm, it does change when I make changes in my sample model. Using the Oracle 12c DBMS, I set the following on a Reference:
and here's the SQL preview:
Now if I change the options and uncheck Disable and Validate, the SQL changes:
With some experimentation I can see that NOVALIDATE doesn't appear if I check Disable and uncheck Validate.
I'm not an expert on Oracle, so I can only assume that this is valid :). You can see the code that creates this part of the SQL in the DBMS definition file - "Profile\Reference\Extended Attributes\refrOptions"
Sorry I can't help you any more, as I don't know what you mean by "not null check level" in this context.
Add comment