Hello,
I have been playing around with DDL Template Editor in EA (V. 12.0.01211), and specifically looking at the DDL for Oracle, but I think this is a broader question/inquiry...
It is really nice how the editor signifies keywords, such as Macros, options... etc.
I also like how if you hover the mouse over the word, it will give you a little description...
My issue is, Where can I get a full list of all possible valid 'keywords'.
My biggest concern is the field reference macros, as I am trying to display certain things in my script.
Let me give you a couple of examples...
First, please note these come from the default DDL Templates...
TEMPLATE: DDL Name, Lines 49 & 50:
%elseIf $parameter2 == "CONSTRAINT"%
$name=%[highlight]ddlConstraintName[/highlight]%
ddlConstraintName is clearly the Name of the Constraint (as viewed through Database Builder). But what other properties can be displayed through macros?
<I will point out currently, I am looking for the condition info from Constraint window (lower/left hand pain).
I could not find any documentation (or search) that mentions Macros like ddlConstraintName... Where can I get these?
TEMPLATE: DDL Check Constraint
Line 15: (%[highlight]constraintProperty[/highlight]:"CHECKSTATEMENT"%)
In the above case, the command is pulling the value from constraintProperty for the property 'CHECKSTATEMENT'.
How is this property created? Where do I store this information?
Is there a guide or document somewhere that shows all possible values?
Thanks,
Bryan