add support for DB2 feature OPTIMIZE FOR xx ROWS in SELECT ---------------------------------------------------------- Key: HHH-3700 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3700 Project: Hibernate Core Issue Type: Improvement Components: core Environment: DB2 UDB for ISeries 5.4 Reporter: Simon Jongsma It would be nice to have support for the (new) DB2 feature OPTIMIZE FOR xx ROWS. This clause can be added at the end of a SELECT statement. Hibernate could use the setMaxResults() value for xx (if it was provided). Hooks for this type of functionality could be implemented in the Dialect class. Example: public String addOptimizationClause(int maxResults, String select) { return select; } I tried to use the transformSelectString method that is in the Dialect class to add the suffix myself, but this did not work. transformSelectString is not consitently called (see HHH-3307). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira