Sybase IQ (E)BNF Grammar or Parser (Java)

[Former Member]

Good Evening

I'm looking for either a parser or the grammar description in (e)bnf for Sybase IQ T-SQL. I'm tinkering around with a small project for my colleagues and for this I need the possibility to check any block of Sybase IQ T-SQL for correctness.

Could somebody please give me a hint? I spent the best of this Afternoon searching the web but without finding something useful.

Thank you very much.

Best regards

Alex

[Former Member · Accepted solution]

Hi Alex,

I think that you looking for the EBNF to use it as a sort of exercise? I dont know any source where to get it from but, be aware if you speak about IQ ist not nessecerly T-SQL but might be WATCOM SQL (hope this ist still true, haven't used IQ a while?)

but for TSQl use http://msdn.microsoft.com/en-us/library/ff848766.aspx as a start because SQL-Server is pretty close to ASE, so you have to find only the diffrences betwen MS and SAP then.

HTH

dj

[Former Member · Accepted solution]

Good evening

First, thanks to all of you for your suggestions. I think I'll try it with the TSQL- or Watcom-Grammar. I thought it would be nice to build a tool for my colleagues to lower their workload. We're running a lot of really big lists of statements and I'm looking for a way, to parameterize the blocks of SQL code, so you can use them like lego-bricks...  

Best regards

Alex