Hello,
I work with DB2 9.7 and the reverse DDL of DBeaver(2.0.3) supply an incorrect DDL when the table is partitionned and compressed:
DBeaver DDL:
CREATE TABLE TMP_EXERCICE_MAX (
NO_PART SMALLINT NOT NULL,
NO_REF_ID DECIMAL,
COD_FEDE_ADH CHAR(1),
EXERCICE CHAR(4)
);
Ibm db2look DDL:
CREATE TABLE CCA.TMP_EXERCICE_MAX (
NO_PART SMALLINT NOT NULL WITH DEFAULT 0 ,
NO_REF_ID DECIMAL(14,0) ,
COD_FEDE_ADH CHAR(1) ,
EXERCICE CHAR(4) )
COMPRESS YES
INDEX IN PART_I PARTITION BY RANGE(NO_PART)
(
PART PART0 STARTING(0) ENDING(0) IN PART_01_D INDEX IN PART_01_I,
PART PART1 STARTING(1) ENDING(1) IN PART_02_D INDEX IN PART_02_I,
PART PART2 STARTING(2) ENDING(2) IN PART_03_D INDEX IN PART_03_I,
PART PART3 STARTING(3) ENDING(3) IN PART_04_D INDEX IN PART_04_I,
PART PART4 STARTING(4) ENDING(4) IN PART_05_D INDEX IN PART_05_I,
PART PART5 STARTING(5) ENDING(5) IN PART_06_D INDEX IN PART_06_I,
PART PART6 STARTING(6) ENDING(6) IN PART_07_D INDEX IN PART_07_I,
PART PART7 STARTING(7) ENDING(7) IN PART_08_D INDEX IN PART_08_I,
PART PART8 STARTING(8) ENDING(8) IN PART_09_D INDEX IN PART_09_I,
PART PART9 STARTING(9) ENDING(9) IN PART_10_D INDEX IN PART_10_I,
PART PART10 STARTING(10) ENDING(10) IN PART_10_D INDEX IN PART_10_I,
PART PART11 STARTING(11) ENDING(11) IN PART_11_D INDEX IN PART_11_I,
PART PART12 STARTING(12) ENDING(12) IN PART_12_D INDEX IN PART_12_I,
PART PART13 STARTING(13) ENDING(13) IN PART_13_D INDEX IN PART_13_I,
PART PART14 STARTING(14) ENDING(14) IN PART_14_D INDEX IN PART_14_I);
thanks in advance