Support for NEXTVAL property in DB2 mode

[kdebski85]

I use H2 in DB2 mode for tests.

I am getting the next value for a sequence with:
SELECT TEST_SEQUENCE.NEXTVAL FROM SYSIBM.SYSDUMMY1

It worked fine for both DB2 (LUW) and H2 (in DB2 mode).
After I upgraded H2 to 2.1.212, it stopped working.

http://www.h2database.com/html/migration-to-v2.html says that
Undocumented Oracle-style .NEXTVAL and .CURRVAL expressions are restricted to Oracle compatibility mode.

However, this expression should also work in DB2 mode because it works on real DB2.

[katzyn]

Do you really need to use that weird command instead of fully standard-compliant

VALUES NEXT VALUE FOR sequenceName;

that works in both DB2 and H2?

[kdebski85]

Thank you.
I will change to use VALUES NEXT VALUE FOR sequenceName in my code.