package net.sf.hibernate.dialect;

/**
* An SQL dialect for DB2/390
* @author
* This class provides support for DB2 Universal Database for OS/390,
* also known as DB2/390.
*/
public class DB2390Dialect extends DB2Dialect {

   public DB2390Dialect() {
      super();
   }

   public boolean supportsSequences() {
      return false;
   }

    public String getIdentitySelectString() {
      return "SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM.SYSDUMMY1";
    }


   public boolean supportsLimit() {
      return true;
   }

   public boolean supportsLimitOffset() {
      return false;
   }

   public String getLimitString(String sql, boolean hasOffset, int limit) {
      return new StringBuffer(sql.length() + 40)
         .append(sql)
         .append(" fetch first ")
         .append(limit)
         .append(" rows only ")
         .toString();
   }

   public boolean useMaxForLimit() {
      return true;
   }

   public boolean supportsVariableLimit() {
      return false;
   }

}

SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM.SYSDUMMY1