Just to point out...BNF won't tell you if indexe, mqts, triggers or
constraints are used in a statement. The DBMS references those behind the

Well technically, I think you could have a statement reference a MQT
directly...but that would appear as simply another table/view reference.

What are you trying to accomplish?


On Wed, Dec 16, 2015 at 10:23 AM, David Gibbs <david@xxxxxxxxxxxx> wrote:

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.


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.


IBM i on Power Systems: For when you can't afford to be out of business!

I'm riding 100 miles (a full century) in the American Diabetes
Association's Tour de Cure to raise money for diabetes research, education,
advocacy, and awareness. You can make a tax deductible donation to my ride
by visiting http://listsig.diabetessucks.net. My goal is $6000 but any
amount is appreciated.

See where I get my donations from ... visit
http://listsig.diabetessucks.net/map for an interactive map (it's a geeky
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

This thread ...


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

This mailing list archive is Copyright 1997-2020 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].