AnsweredAssumed Answered

DB2 z/OS support

Question asked by pero on May 10, 2011
Latest reply on Jan 14, 2014 by trademak
This kind of query is not supported by DB2 version 9.1 for z/OS database:

create table ACT_RU_EXECUTION (
    ID_ varchar(64) not null,
    REV_ integer,
    PROC_INST_ID_ varchar(64),
    BUSINESS_KEY_ varchar(255),
    PARENT_ID_ varchar(64),
    PROC_DEF_ID_ varchar(64),
    SUPER_EXEC_ varchar(64),
    ACT_ID_ varchar(255),
    IS_ACTIVE_ smallint check(IS_ACTIVE_ in (1,0)),
    IS_CONCURRENT_ smallint check(IS_CONCURRENT_ in (1,0)),
    IS_SCOPE_ smallint check(IS_SCOPE_ in (1,0)),
   UNI_BUSINESS_KEY varchar (255)  not null  generated always as (case when "BUSINESS_KEY_" is null then "ID_" else "BUSINESS_KEY_" end),
   UNI_PROC_DEF_ID varchar (64)  not null  generated always as (case when "PROC_DEF_ID_" is null then "ID_" else "PROC_DEF_ID_" end),
    primary key (ID_)
);

The problem is that "case" expression is not supported under "generated always as" for this DB2 version.
I see that ACT_RU_EXECUTION table for other databases(postgres) doesn't contain UNI_BUSINESS_KEY and UNI_PROC_DEF_ID columns at all.
What if we don't define those columns on our db2? Will activiti still work?

Is there some other solution to this problem possibly?

Thanks.

Outcomes