Hi - Who knows? You'd have to try on your own to really know for sure.
H2's concept of procedural language SQL manifests itself through UDF and pluggable Table Engines - both extremely powerful and infinitely configurable. You can start here. http://www.h2database.com/html/features.html#user_defined_functions Let us know how it goes - we're very curious to know if H2 satisfies your test case (and more importantly, if you were able to meet your "urgent" deadline). On Mon, Dec 23, 2013 at 12:34 PM, SHIVAM MAHARSHI <[email protected]>wrote: > Hi, > > I am evaluating some in-memory databases. *I need to know wether > H2Database supports SQL variables? * > > Statements like: "DECLARE @clientAppInstId VARCHAR(50)" > > *My Query works in the SQL database and I need a InMemory database for > test cases purpose which can run this query given below:* > > DECLARE @clientAppInstId VARCHAR(50) > SET @clientAppInstId = (SELECT ClientAppInstanceId FROM core_securityToken > WHERE TokenId = '1234') > IF(@clientAppInstId is null) > SELECT cst.UserId > FROM > dbo.core_SecurityToken cst (NOLOCK) > ELSE > SELECT > cst.Uri > FROM > dbo.core_SecurityToken cst (NOLOCK) > > *This query will require the support of SQL Variables and IF/ELSE > keywords.* > > *Need to know is this supported in **H2Database** on an urgent basis? I > am in the middle of a sprint. Quick answer will be highly appreciated.* > > *Best,* > > *Shivam* > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
