Why are sequence related functions omitted for db/2

[Akhil Kumar <r1...@in.ibm.com>]

Hi,

I came to know today that Sequences are supported in db/2
I checked v 7.2 and v 8.1 both have it.
Is there any other reason why the ***sequecequery methods are not
implemented for platformdb2impl.

org.apache.ojb.broker.platforms.platformDb2impl
should have all three Sequence related functions
The syntax of create and drop is same as Oracle.
Following is the syntax for Next Sequence

public String nextSequenceQuery(String sequenceName)
{
      return "values nextval for "+sequenceName ;
}
/// these two are same as oracle.
public String dropSequenceQuery(String sequenceName)
{
      return "drop sequence " + sequenceName;
}
public String createSequenceQuery(String sequenceName)
{
      return "create sequence " + sequenceName;
}

Should I submit a patch for this ? seems too trivial to have my name on
it...

Regards,
Akhil Kumar



---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org