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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]