Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Apr 05, 2016 at 01:27 PM

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

    Sorry for the noise.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.