Re: Grammar file for SQL

Hi Harshad,

Ain't sure if such a public tool exists.

However, there are available grammars at the javacc site for PL/SQL:
https://javacc.dev.java.net/servlets/ProjectDocumentList?folderID=110&expandFolder=110&folderID=0

Also you may find useful the following links:
http://jsqlparser.sourceforge.net/
http://www.nabble.com/JJTree-Javacc---SQL-Grammar-Parser-to-expose-%22sql-parts%22-td19299305.html
http://www.ibm.com/developerworks/data/library/techarticle/dm-0401brereton/index.html

Hope that helps something.

Best regards,
---
Richard O. Legendi, programmer
AITIA International Inc.
E-mail: rlegendi@...

Harshad Chavan wrote:
> Hi all,
>
> has anyone written a grammar file for SQL queries? Specifically, we want
> to port mysql queries to db2 queries. Has anyone done that before?
>
> Appreciate any help.
>
> Harshad


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...