On 12/15/2015 4:48 PM, Sue Romano wrote:
As the primary owner of the IBM i SQL BNF, I would be interested in
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.

Sue:

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.

david



This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].