com.github.changemonitor.dialect.Db2Dialect Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of changemonitor Show documentation

The newest version!

package com.github.changemonitor.dialect;


public class Db2Dialect  extends AbstractDialect {
	@Override
	public String getLimitSql(String sql, Integer limitSize) {
		StringBuilder sqlBuilder = new StringBuilder(sql.length() + 120);
        sqlBuilder.append("SELECT * FROM (SELECT TMP_PAGE.*,ROWNUMBER() OVER() AS ROW_ID FROM ( ");
        sqlBuilder.append(sql);
        sqlBuilder.append(" ) AS TMP_PAGE) WHERE ROW_ID BETWEEN ");
        sqlBuilder.append(1);
        sqlBuilder.append(" AND ");
        sqlBuilder.append(limitSize);
        return sqlBuilder.toString();
	}
}