Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Using JSqlParser to find table names from a DB2 SQL Query #2278

Unanswered
NikJoj asked this question in Q&A
Discussion options

As part of one of my requirements to analyse the sql queries running on a database, I was planning to integrate a parser. The major requirement here is to get the table list (referenced in the query) and identify the query type (select, insert, delete, update). Thinking of using the open source JSqlParser package available for java. The documentation does say Database agnostic, but I wanted to check with you folks if any of you have used this package and if it works well with Db2 SQL queries. Please share your thoughts.

TLDR : Is JSqlParser package suitable to parse and find the tables referenced in DB2 SQL Queries?

https://mvnrepository.com/artifact/com.github.jsqlparser/jsqlparser
https://github.com/JSQLParser/JSqlParser
https://jsqlparser.github.io/JSqlParser/

You must be logged in to vote

Replies: 2 comments

Comment options

Yes, you can.

You must be logged in to vote
0 replies
Comment options

You must be logged in to vote
0 replies
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet

AltStyle によって変換されたページ (->オリジナル) /