Eclipse Community Forums: DTP » how extended DTP SQL parser so that it can resolve the specific keywords of specific db vendor

Home » Eclipse Projects » DTP » how extended DTP SQL parser so that it can resolve the specific keywords of specific db vendor

Show: Today's Messages :: Show Polls :: Message Navigator

how extended DTP SQL parser so that it can resolve the specific keywords of specific db vendor [message #1444492]

Tue, 14 October 2014 06:29

LV Frank

Messages: 3
Registered: October 2014

Junior Member

Now,I have a problem in use dtp plugins.

In my case, I want to use DTP SQL Query Parser to parse SQL of specific db, but there are some keywords can't be successfully resolved like TOP（MS SQL）、LIMIT 0（MySql）and so on. When I typed SQL contained these keyword,the dtp will prompt an formatting error.

Is there any simple way to modify existing content（org.eclipse.datatools.sqltools.parsers.sql.lexer & org.eclipse.datatools.sqltools.parsers.sql.query） to fix?

If not ,how to extend the parser to support vendor specific dialects and custom source generation?

I found this:https://www.eclipse.org/datatools/project_sqldevtools/sqltools_doc/SQL%20Query%20Parser%20User%20documentation.htm

but it's too simple to tell me how to do use lpg to generate my own parser.

So is there anyone who can help me？

Report message to a moderator

Previous Topic:	DTP Support for Progress DB
Next Topic:	SQL Query Parser - standalone, db2 plugin?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Oct 23 12:08:39 GMT 2020

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter