cancel
Showing results for 
Search instead for 
Did you mean: 

DB2 version10, more extensive opportunities of a timestamp

Highlighted
Occasional Contributor

DB2 version10, more extensive opportunities of a timestamp

We use version 10 of DB2 but MEGA does not support version 10.

In DB2 lower versions the number of digits in the fractional seconds portion of a timestamp is specified using an attribute of 6. We would like to have a larger range of 12.

Do we have an alternative to use more extensive opportunities of a timestamp ?

 

Thanks

Jan Cortoos

Tags (3)
3 Replies
MEGA

Re: DB2 version10, more extensive opportunities of a timestamp

Hello Jan

 

With MEGA Database, the generation Target DB2 version 10 is indeed not supported.

 

However, can you explain better, where in the MEGA application (detail or GUI used and action performed), you cannot manage timestamps as you wish to do it.

Jerome
Occasional Contributor

Re: DB2 version10, more extensive opportunities of a timestamp

Hello Jerome,

 

When we create a DDL-file in db2-version 8 it looks like this :
( there is only one type of timestamp created by 'p-timestamp' in package 'pivot')


CREATE TABLE CBTRKO07
(
  REG_DS TIMESTAMP NOT NULL,
  VNS_NR CHAR(4) NOT NULL WITH DEFAULT,
  CTT_NR CHAR(7) NOT NULL WITH DEFAULT,
  ...

 We would  like to be able to create a DDL like this : (timestamp can have a variable number of characters)

CREATE TABLE
       CERATEST.CBTDBETS
        (
        DBE_NO  CHAR(7) NOT NULL
         FOR SBCS DATA
       ,TS_Z_TZ  TIMESTAMP NOT NULL WITH DEFAULT
       ,TS_0_Z_TZ  TIMESTAMP(0) NOT NULL WITH DEFAULT
       ,TS_1_Z_TZ  TIMESTAMP(1) NOT NULL WITH DEFAULT
       ,TS_2_Z_TZ  TIMESTAMP(2) NOT NULL WITH DEFAULT
       ,TS_3_Z_TZ  TIMESTAMP(3) NOT NULL WITH DEFAULT
       ,TS_4_Z_TZ  TIMESTAMP(4) NOT NULL WITH DEFAULT
       ,TS_5_Z_TZ  TIMESTAMP(5) NOT NULL WITH DEFAULT
       ,TS_6_Z_TZ  TIMESTAMP(6) NOT NULL WITH DEFAULT
       ,TS_7_Z_TZ  TIMESTAMP(7) NOT NULL WITH DEFAULT
       ,TS_8_Z_TZ  TIMESTAMP(8) NOT NULL WITH DEFAULT
       ,TS_9_Z_TZ  TIMESTAMP(9) NOT NULL WITH DEFAULT
       ,TS_10_Z_TZ  TIMESTAMP(10) NOT NULL WITH DEFAULT
       ,TS_11_Z_TZ  TIMESTAMP(11) NOT NULL WITH DEFAULT
       ,TS_12_Z_TZ  TIMESTAMP(12) NOT NULL WITH DEFAULT
       ,TS_Y_TZ  TIMESTAMP WITHOUT TIME ZONE
                                NOT NULL WITH DEFAULT
       ,TS_0_Y_TZ  TIMESTAMP(0) WITHOUT TIME ZONE
                                NOT NULL WITH DEFAULT
       ,TS_1_Y_TZ  TIMESTAMP(1) WITHOUT TIME ZONE
                                NOT NULL WITH DEFAULT
       ,TS_2_Y_TZ  TIMESTAMP(2) WITHOUT TIME ZONE
                                NOT NULL WITH DEFAULT
       ,TS_3_Y_TZ  TIMESTAMP(3) WITHOUT TIME ZONE
                                NOT NULL WITH DEFAULT
       ,TS_4_Y_TZ  TIMESTAMP(4) WITHOUT TIME ZONE
                                NOT NULL WITH DEFAULT
       ,TS_5_Y_TZ  TIMESTAMP(5) WITHOUT TIME ZONE
                                NOT NULL WITH DEFAULT
       ,TS_6_Y_TZ  TIMESTAMP(6) WITHOUT TIME ZONE
                                NOT NULL WITH DEFAULT
       ,TS_7_Y_TZ  TIMESTAMP(7) WITHOUT TIME ZONE
                                NOT NULL WITH DEFAULT
       ,TS_8_Y_TZ  TIMESTAMP(8) WITHOUT TIME ZONE
                                NOT NULL WITH DEFAULT
       ,TS_9_Y_TZ  TIMESTAMP(9) WITHOUT TIME ZONE
                                NOT NULL WITH DEFAULT
       ,TS_10_Y_TZ  TIMESTAMP(10) WITHOUT TIME ZONE
                                NOT NULL WITH DEFAULT
       ,TS_11_Y_TZ  TIMESTAMP(11) WITHOUT TIME ZONE
                                NOT NULL WITH DEFAULT
       ,TS_12_Y_TZ  TIMESTAMP(12) WITHOUT TIME ZONE
                                NOT NULL WITH DEFAULT
       ,TS_W_TZ  TIMESTAMP WITH TIME ZONE NOT NULL WITH DEFAULT
       ,TS_0_W_TZ  TIMESTAMP(0) WITH TIME ZONE NOT NULL WITH DEFAULT
       ,TS_1_W_TZ  TIMESTAMP(1) WITH TIME ZONE NOT NULL WITH DEFAULT
       ,TS_2_W_TZ  TIMESTAMP(2) WITH TIME ZONE NOT NULL WITH DEFAULT
       ,TS_3_W_TZ  TIMESTAMP(3) WITH TIME ZONE NOT NULL WITH DEFAULT
       ,TS_4_W_TZ  TIMESTAMP(4) WITH TIME ZONE NOT NULL WITH DEFAULT
       ,TS_5_W_TZ  TIMESTAMP(5) WITH TIME ZONE NOT NULL WITH DEFAULT
       ,TS_6_W_TZ  TIMESTAMP(6) WITH TIME ZONE NOT NULL WITH DEFAULT
       ,TS_7_W_TZ  TIMESTAMP(7) WITH TIME ZONE NOT NULL WITH DEFAULT
       ,TS_8_W_TZ  TIMESTAMP(8) WITH TIME ZONE NOT NULL WITH DEFAULT
       ,TS_9_W_TZ  TIMESTAMP(9) WITH TIME ZONE NOT NULL WITH DEFAULT
       ,TS_10_W_TZ  TIMESTAMP(10) WITH TIME ZONE NOT NULL WITH DEFAULT
       ,TS_11_W_TZ  TIMESTAMP(11) WITH TIME ZONE NOT NULL WITH DEFAULT
       ,TS_12_W_TZ  TIMESTAMP(12) WITH TIME ZONE NOT NULL WITH DEFAULT
        ,
         CONSTRAINT PK_CBTDBETS

 

Thanks

Jan

 

MEGA

Re: DB2 version10, more extensive opportunities of a timestamp

Hello Jan

 

It seems that a specific implementation is required to manage this kind of DDL.

As far as I know, the support of the generation target DB2 V10 is not planned for the moment.

 

If this is important to you and you need some assistance to study a specific implementation, I suggest you contact your MEGA account manager. 

Jerome