On 12/15/2015 4:48 PM, Sue Romano wrote:
As the primary owner of the IBM i SQL BNF, I would be interested inSue:
hearing what you are looking for in the statement text. If it is
something that might be generally useful (like a list of table
names), I might be able to create a service that uses the IBM i
parser to return these pieces of information.
I'm primarily interested in parsing SQL source to identify objects used in the statement.
For example: Tables & views used by views, indexes, & mqts. Also, constraint relationships, triggers, etc.
I have the ability to process a BNF into a parser program, but an API that gives me the information would be even better.