Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Netezza forward engineering, distribution clause

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




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
Former Member replied

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

Sorry for the noise.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question