Netezza forward engineering, distribution clause
In the PDM [Table Properties -> Options] I can set the distribution clause for a table. But this is not coming out in forward engineering.
In [Model Properties -> DBMS Properties -> Profile -> Table -> Extended Attributes] I see how the Options interface seems to be defined for setting the distribution. But, I need to get the distribution clause to show up in Forward Engineering.
In [Model Properties -> DBMS Properties -> Script -> Objects -> Table -> Create] I see the following code:
create [%Type%=TEMP?[.O:[temporary ][temp ]]]table [%QUALIFIER%]%TABLE% (
Do I add something to the above code to get the distribution settings to show up?
create table t1
,fld character varying(100))
distribute on (id);
Please disregard this posting. The distribution clause is coming out while Forward Engineering for Netezza.
Sorry for the noise.