Hi, I didn't know about PREVIOUS VALUE FOR <sequence>. I will add a feature request, but not implement it currently, sorry.
Regards, Thomas On Wed, Jul 29, 2009 at 11:21 AM, Nitin Gautam<[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
