Netezza forward engineering, distribution clause

[Former Member]

Hi all,

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% (

   %TABLDEFN%

)

%TableOption%

Do I add something to the above code to get the distribution settings to show up? 

create table t1

(id int

,fld character varying(100))

distribute on (id);

Somewhere else?

[Former Member · Accepted solution]

Please disregard this posting.  The distribution clause is coming out while Forward Engineering for Netezza.

Sorry for the noise.

[Former Member · Accepted solution]

Well,

I'm back to this issue.  In one Netezza physical model I see the distribution clause being forward engineered, yet in another Netezza physical model the distribution clause is not being forward engineered.  Does anybody know where I could go in PD to change this behavior?

[Former Member · Accepted solution]

Okay,

I renamed the underlying physical model to xxx.sv.  Then redid the "Generate Physical Model" from the Logical.  This newly created Physical Model forward engineers the chosen distribution clause.  Minor irritant, but at least a solution.