Sequence support for DB2400Dialect ---------------------------------- Key: HHH-1754 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1754 Project: Hibernate3 Issue Type: Improvement Components: core Affects Versions: 3.1.3 Environment: Hibernate 3.1.3, IBM DB2 UDB for iSeries on i5/OS V5R3 Reporter: Carey Evans Priority: Minor Attachments: DB2400Dialect.java As of i5/OS V5R3 (the operating system previously known as OS/400), DB2 supports sequences, but DB2400Dialect doesn't include support for the new functionality. This support can be modelled on DB2Dialect, except that "values ..." must be written "select ... from sysibm.sysdummy1", and the syssequences view is in the qsys2 schema. I don't know what impact this change would have on older versions of OS/400 that don't support sequences. The attached DB2400Dialect source includes sequence support, with some additional minor corrections for timestamps on i5/OS.