Re: DB2 for i "Backus?Naur Form" specification

David:

Look in the "DB2 for i SQL Reference" for 7.1, and search for "DESCRIBE" ... there are several forms of the SQL DESCRIBE statement that can be used in a program (as "embedded SQL"):

DESCRIBE statement-name INTO :sqlda;
or
DESCRIBE CURSOIR USING SQL DESCRIPTOR 'DESCR1';
or
DESCRIBE PROCEDURE P1 USING SQL DESCRIPTOR 'DESC1';
or
DESCRIBE TABLE :tableName INTO :sqlda;

The various DESCRIBE statements return all sorts of information about the target in a (possibly large) SQLDA data structure.

HTH,

Mark S. Waterbury

> On 12/16/2015 10:23 AM, David Gibbs 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.

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