Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » SQL Query Parser - standalone, db2 plugin?
SQL Query Parser - standalone, db2 plugin? [message #1022818] Fri, 22 March 2013 11:25 Go to next message
Leonardo Herrera is currently offline Leonardo Herrera
Messages: 2
Registered: March 2013
Junior Member
Hello all,

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?

Kind regards,
Leonardo Herrera
Re: SQL Query Parser - standalone, db2 plugin? [message #1037462 is a reply to message #1022818] Tue, 09 April 2013 11:28 Go to previous message
Leonardo Herrera is currently offline Leonardo Herrera
Messages: 2
Registered: March 2013
Junior Member
Hm- Hello?
Previous Topic:Problem in Quantum DB with sajdbc4.jar (SQL Anywhere)
Next Topic:Show Errors on Oracle PL/SQL compile?
Goto Forum:
  


Current Time: Sat Aug 23 11:30:39 EDT 2014

Powered by FUDForum. Page generated in 0.08107 seconds