IBM WebSphere Multichannel Bank Transformation Toolkit, Version 7.1

Default createCHATables.ddl contents

The following is the content of createCHATables.ddl file provided by the toolkit for DB2®:

CREATE TABLE CHAINSTANCE
  (INSTANCEID VARCHAR(250) NOT NULL,
   NAME VARCHAR(250),
   PARENTID VARCHAR(250),
   ISROOT SMALLINT NOT NULL,
   CONTEXT BLOB(1000000),
   TYPENAME VARCHAR(250));

ALTER TABLE CHAINSTANCE
  ADD CONSTRAINT PK_CHAINSTANCE PRIMARY KEY (INSTANCEID);

CREATE INDEX AAA ON CHAINSTANCE(PARENTID);

CREATE TABLE CHACONTROL
  (NUM INTEGER NOT NULL,
   INSTIDPREFIX INTEGER,
   HASCTXTREE SMALLINT NOT NULL);

ALTER TABLE CHACONTROL
  ADD CONSTRAINT PK_CHACONTROL PRIMARY KEY (NUM);

You can define the length of the Context field in the CHAInstance table according to your business need.



Feedback