public DerbyDialect() 
{
		super();
		registerFunction( "concat", new DerbyConcatFunction() );
		registerFunction( "trim", new DerbyTrimFunctionEmulation() );
}

 public CaseFragment createCaseFragment() 
{
		return new DerbyCaseFragment();
}

Return the case statement modified for Cloudscape.

 public boolean dropConstraints() 
{
	      return true;
}

 public String getIdentityColumnString() 
{
		return "not null generated always as identity"; //$NON-NLS-1
}

This is different in Cloudscape to DB2.

 public Class getNativeIdentifierGeneratorClass() 
{
		return TableHiLoGenerator.class;
}

 public String getQuerySequencesString() 
{
	   return null ;
}

 public boolean supportsLimit() 
{
		return false;
}

 public boolean supportsLimitOffset() 
{
		return false;
}

 public boolean supportsLobValueChangePropogation() 
{
		return false;
}

 public boolean supportsSequences() 
{
		return false;
}