net.sf.jkniv.whinstone.jdbc.dialect

Class DB2EnableORADialect

java.lang.Object

net.sf.jkniv.sqlegance.dialect.AnsiDialect

net.sf.jkniv.whinstone.jdbc.dialect.DB2EnableORADialect

All Implemented Interfaces:

SqlDialect

public class DB2EnableORADialect
extends AnsiDialect

Dialect to DB2 with compatibility features for Oracle applications.

Limit clause: SELECT TEXT FROM SESSION.SEARCHRESULTS WHERE ROWNUM BETWEEN 20 AND 40 ORDER BY ID

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

The DB2_COMPATIBILITY_VECTOR registry variable enables one or more DB2® compatibility features. These features ease the task of migrating applications that were written for relational database products other than the DB2 product to DB2 Version 9.5 or later.

This registry variable is supported on Linux, UNIX, and Windows operating systems. You can enable individual DB2 compatibility features by specify a hexadecimal value for the registry variable. Each bit in the variable value enables a different feature. Values are as follows:

   NULL (default)
   0000 - FFFF
   ORA, to take full advantage of the DB2 compatibility features for Oracle applications
   SYB, to take full advantage of the DB2 compatibility features for Sybase applications
   MYS, to take full advantage of the DB2 compatibility features for MySQL applications
 

Since:

0.6.0

Author:

Alisson Gomes

See Also:

DB2 compatibility Oracle/Sybase/MySQL

Field Summary

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

name, patternORDER_BY

Constructor Summary

Constructors

Constructor and Description
DB2EnableORADialect()

Method Summary

Modifier and Type	Method and Description
String	buildQueryPaging(String sqlText, int offset, int max) Build a paginate query accordingly data base dialect
String	getSqlPatternPaging() Using rownum to paging the select, COMPATIBILITY_VECTOR=ORA must be enabled.

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

addFeature, buildQueryCount, 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

DB2EnableORADialect

public DB2EnableORADialect()

Method Detail

getSqlPatternPaging

public String getSqlPatternPaging()

Using rownum to paging the select, COMPATIBILITY_VECTOR=ORA must be enabled.

Specified by:

getSqlPatternPaging in interface SqlDialect

Overrides:

getSqlPatternPaging in class AnsiDialect

Returns:

Return query pattern: select * from (%1$s) where rownum between %3$s and %2$s

buildQueryPaging

public String buildQueryPaging(String sqlText,
                               int offset,
                               int max)

Description copied from interface: SqlDialect

Build a paginate query accordingly data base dialect

Specified by:

buildQueryPaging in interface SqlDialect

Overrides:

buildQueryPaging in class AnsiDialect

Parameters:

sqlText - final SQL with parameters to bind

offset - number from first row from query result

max - maximum number of rows from query result.

Returns:

paginate query for specific data base dialect