-
-
Notifications
You must be signed in to change notification settings - Fork 1.4k
-
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
Replies: 2 comments
-
Yes, you can.
Beta Was this translation helpful? Give feedback.
All reactions
-
https://github.com/JSQLParser/JSqlParser/wiki/Examples-of-SQL-parsing --> extract table names from sql
Beta Was this translation helpful? Give feedback.
All reactions
-
👍 1