Thanks for Reply Bob. But I don't want to modify my existing DB2 DAO code as CURRVAL is not supported by DB2. So I rewrite the Query before execution and replaced the instances of PREVVAL with CURRVAL syntax :-)
On Jul 28, 9:12 pm, bob mcgee <[email protected]> wrote: > Syntax in your case: > SELECT CURRVAL(ID_GEN); > > In H2, this is considered to be the current value, since it is in use, > being assigned to something. > Grammar entry for the CURRVAL > function:http://www.h2database.com/html/functions.html#currval > > Cheers, > Bob McGee --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
