|SQL Query Parser - standalone, db2 plugin? [message #1022818]
||Fri, 22 March 2013 15:25
| Leonardo Herrera
Registered: March 2013
Just recently discovered the SQL Query Parser classes in the DTP project, and it looks like a great (and unique) project.
My problem is that I need to analyze and see if I can merge some pretty hairy SQL fragments that are used in a big system. I need a smart and capable parser so I can perform an accurate analysis and determine if I can join some of these fragments together to improve performance. This needs to be somewhat smart, and I've figured the analysis I need to perform; however, the parser as-is is not able to parse these fragments, because they use specific db2 OLAP functions (over(), partition by, etc.) so I need to include the db2 plugins to my code.
How is this done? I haven't been able to find the classes ('org.eclipse.datatools.sqltools.parsers.sql.query.db2', etc.) anywhere, and I also have no idea how to register them (I'm trying to do it manually, but of course it cannot find the appropriate class.)
Can somebody help me with this problem?
Powered by FUDForum
. Page generated in 0.01741 seconds