建联合主键报错DB2 Database Error: ERROR [42997] [IBM][DB2/AIX64] SQL0270N Function not supported (Reason c

CREATE TABLE "mmm"."test" (   --建表语句
  "A" DATE,
  "B" VARCHAR(36),
  "C" VARCHAR(50),
  "D" VARCHAR(25) not null,
  "E" VARCHAR(15) not null,

  ) IN "MA_DATA"

DISTRIBUTE BY hash ("C") ; 

alter table "mmm"."test" add primary key(D,E);   --创建联合主键语句  就是运行这个语句时报此错误；

错误原因是必须要把 DISTRIBUTE BY hash ("C") ;  改为联合主键的任意一个字段就ok了

如下 

drop table "mmm"."test" ;

CREATE TABLE "mmm"."test" (   --建表语句
  "A" DATE,
  "B" VARCHAR(36),
  "C" VARCHAR(50),
  "D" VARCHAR(25) not null,
  "E" VARCHAR(15) not null,

  ) IN "MA_DATA"

DISTRIBUTE BY hash ("D") ;