Eclipse Community Forums: DTP » SQL Parsing of DB2 dialect

Help

Home

Home » Eclipse Projects » DTP » SQL Parsing of DB2 dialect

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

SQL Parsing of DB2 dialect [message #28399]

Wed, 28 March 2007 15:11

Eclipse User

Originally posted by: efratn.hotmail.com

I'm trying to parse some DB2 queries, that contain a db2 comment, like:

select * from customer -- here is the comment

the generic SQLQueryParserManager fails on this.

In the documentation it says to call the SQLQueryParserManager with the
dbVendor and dbVersion,
but this doesn't seem to help - maybe I'm missing some requiered
jars/plugins?

Thanks
Efrat

Report message to a moderator

Re: SQL Parsing of DB2 dialect [message #30482 is a reply to message #28399]

Thu, 03 May 2007 20:40

Brian Payton

Messages: 154
Registered: July 2009

Senior Member

The SQLQueryParser should work OK with comments. What is the error you
are getting?

Brian Payton
DTP SQL Development Tools committer
IBM

Efrat wrote:
> I'm trying to parse some DB2 queries, that contain a db2 comment, like:
>
> select * from customer -- here is the comment
>
> the generic SQLQueryParserManager fails on this.
>
> In the documentation it says to call the SQLQueryParserManager with
> the dbVendor and dbVersion,
> but this doesn't seem to help - maybe I'm missing some requiered
> jars/plugins?
>
>
> Thanks
> Efrat
>

Report message to a moderator