As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
<br>create table ACT_RU_EXECUTION (<br> ID_ varchar(64) NOT NULL,<br> REV_ integer,<br> PROC_INST_ID_ varchar(64),<br> BUSINESS_KEY_ varchar(255),<br> PARENT_ID_ varchar(64),<br> PROC_DEF_ID_ varchar(64),<br> SUPER_EXEC_ varchar(64),<br> ACT_ID_ varchar(255),<br> IS_ACTIVE_ SMALLINT CHECK(IS_ACTIVE_ IN (1,0)),<br> IS_CONCURRENT_ SMALLINT CHECK(IS_CONCURRENT_ IN (1,0)),<br> IS_SCOPE_ SMALLINT CHECK(IS_SCOPE_ IN (1,0)),<br> UNI_BUSINESS_KEY VARCHAR (255) NOT NULL GENERATED ALWAYS AS (CASE WHEN "BUSINESS_KEY_" IS NULL THEN "ID_" ELSE "BUSINESS_KEY_" END),<br> UNI_PROC_DEF_ID VARCHAR (64) NOT NULL GENERATED ALWAYS AS (CASE WHEN "BUSINESS_KEY_" IS NULL THEN "ID_" ELSE "PROC_DEF_ID_" END),<br> CONSTRAINT PK_RU_EXECUTION primary key (ID_)<br>);<br>create table ACT_HI_PROCINST (<br> ID_ varchar(64) not null,<br> PROC_INST_ID_ varchar(64) not null,<br> BUSINESS_KEY_ varchar(255),<br> PROC_DEF_ID_ varchar(64) not null,<br> START_TIME_ timestamp not null,<br> END_TIME_ timestamp,<br> DURATION_ bigint,<br> START_USER_ID_ varchar(255),<br> START_ACT_ID_ varchar(255),<br> END_ACT_ID_ varchar(255),<br> UNI_BUSINESS_KEY VARCHAR (255) NOT NULL GENERATED ALWAYS AS (CASE WHEN "BUSINESS_KEY_" IS NULL THEN "ID_" ELSE "BUSINESS_KEY_" END),<br> UNI_PROC_DEF_ID VARCHAR (64) NOT NULL GENERATED ALWAYS AS (CASE WHEN "BUSINESS_KEY_" IS NULL THEN "ID_" ELSE "PROC_DEF_ID_" END),<br> CONSTRAINT PK_HI_PROC_INST primary key (ID_),<br> CONSTRAINT UQ_PROC_INST_ID unique (PROC_INST_ID_)<br>); <br><br>create unique index business_key_ru_idx on ACT_RU_EXECUTION<br> (UNI_BUSINESS_KEY ,UNI_PROC_DEF_ID);<br>create unique index business_key_hi_idx on ACT_HI_PROCINST<br> (UNI_BUSINESS_KEY ,UNI_PROC_DEF_ID);<br>
<dependency><br> <groupId>com.ibm</groupId><br> <artifactId>db2jcc</artifactId><br> <version>3.59.81</version><br> </dependency>
