Hi

I created a ddl file for DB2. I tested it only with DB2 V8, probably it works 
also with other versions. 

-- 
Rafał Kwiecień
ConSol* Consulting & Solutions Software Poland Sp. z o.o.
ul. Piastowska 44C, 30-070 Kraków 
http://www.consol.pl/
create table ${schemaObjectPrefix}BUNDLE (NODE_ID CHAR(16) FOR BIT DATA not 
null, BUNDLE_DATA blob(100M) not null)
create unique index ${schemaObjectPrefix}BUNDLE_IDX on 
${schemaObjectPrefix}BUNDLE (NODE_ID)
create table ${schemaObjectPrefix}REFS (NODE_ID CHAR(16) FOR BIT DATA not null, 
REFS_DATA blob(100M) not null)
create unique index ${schemaObjectPrefix}REFS_IDX on ${schemaObjectPrefix}REFS 
(NODE_ID)
create table ${schemaObjectPrefix}BINVAL (BINVAL_ID varchar(64) not null, 
BINVAL_DATA blob(1000M) not null)
create unique index ${schemaObjectPrefix}BINVAL_IDX on 
${schemaObjectPrefix}BINVAL (BINVAL_ID)
create table ${schemaObjectPrefix}NAMES (ID INTEGER GENERATED ALWAYS AS 
IDENTITY, NAME varchar(255) not null)

Reply via email to