Partitionned table in DB2 9

Note: please leave bug reports and feature requests on

Partitionned table in DB2 9

Postby 5870cve0 » Wed Dec 05, 2012 9:47 am

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
5870cve0
 
Posts: 1
Joined: Wed Dec 05, 2012 9:13 am

Re: Partitionned table in DB2 9

Postby Serge » Wed Dec 05, 2012 11:30 am

Hello,

DBeaver uses Generic driver for DB2 connections. It means it can use only plain JDBC API to read database metadata and it can generate only generic SQL (SQL-92 actually).
Currently we have only two DB specific extensions - for MySQL and Oracle. These plugins generates DDL using special database functions/views. So, DB2 DDL you see is very-very simple form of actual DDL. We'll generate real DDL in DB2 extension which is currently is under construction. Probably it'll be released in the beginning of 2013.

Thanks.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Support



Who is online

Users browsing this forum: No registered users and 14 guests