Replies: 2 comments
-
Yes, you can. |
Beta Was this translation helpful? Give feedback.
0 replies
-
https://github.com/JSQLParser/JSqlParser/wiki/Examples-of-SQL-parsing --> extract table names from sql |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
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/
Beta Was this translation helpful? Give feedback.
All reactions