db2 create sequence

General Discussion
1

We currently don’t support specifying the data type with a createSequence. You could use modifySql with a dbms=“db2” to add the “as decimal” in there.  Something like


  1.    
2

Hi,

I try to create a sequence with a big value.

for oracle is not a problem. but for ibm db2 the syntax is different

for oracle
-> create sequence temp start with 3500000000;

for db2
-> create sequence temp as decimal (31,0) start with 3500000000;

is there a way to create a change set to work with db2 and oracle ?

thanks

julien.


my solution for the moment is

   
       
   

     
       
              create sequence temp as decimal (31,0) start with 3500000000;