net.sf.jkniv.whinstone.jdbc.dialect

Class DB2Dialect

java.lang.Object

net.sf.jkniv.sqlegance.dialect.AnsiDialect

net.sf.jkniv.whinstone.jdbc.dialect.DB2Dialect

All Implemented Interfaces:

SqlDialect

public class DB2Dialect
extends AnsiDialect

Default dialect to DB2.

Limit clause: select name from author FETCH FIRST 20 ROWS ONLY

• Supports limits? true
• Supports limit off set? false
• Supports rownum? false

Since:

0.6.0

Author:

Alisson Gomes

Field Summary

Fields inherited from class net.sf.jkniv.sqlegance.dialect.AnsiDialect

name, patternORDER_BY

Constructor Summary

Constructors

Constructor and Description
DB2Dialect()

Method Summary

Modifier and Type	Method and Description
String	getSqlPatternPaging() LIMIT and OFFSET clause for DB2 with DB2_COMPATIBILITY_VECTOR=MYS enabled, where LIMIT and OFFSET are parameter from String.format

Methods inherited from class net.sf.jkniv.sqlegance.dialect.AnsiDialect

addFeature, buildQueryCount, buildQueryPaging, buildQueryPaging, countOccurrencesOf, getAccessId, getAccessRevision, getMaxOfParameters, getSqlPatternCount, name, setMaxOfParameters, sqlEndsWithOrderBy, sqlEndWithForUpdate, sqlStartWithSelect, sqlStartWithSelectOrDistinct, supportsFeature, supportsParmMark

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DB2Dialect

public DB2Dialect()

Method Detail

getSqlPatternPaging

public String getSqlPatternPaging()

LIMIT and OFFSET clause for DB2 with DB2_COMPATIBILITY_VECTOR=MYS enabled, where LIMIT and OFFSET are parameter from String.format

Specified by:

getSqlPatternPaging in interface SqlDialect

Overrides:

getSqlPatternPaging in class AnsiDialect

Returns:

Return query pattern:

 
   select name from author  FETCH FIRST   20   ROWS ONLY