Re: Parsing some but not all of SQL

"M.G.J. van den Brand" <>
13 Oct 2002 16:03:11 -0400

          From comp.compilers

Related articles
Parsing some but not all of SQL (GuaGuaHuang) (2002-09-25)
Re: Parsing some but not all of SQL (M.G.J. van den Brand) (2002-10-13)
Re: Parsing some but not all of SQL (Hannes liesen) (2002-10-13)
| List of all articles for this month |

From: "M.G.J. van den Brand" <>
Newsgroups: comp.compilers
Date: 13 Oct 2002 16:03:11 -0400
Organization: Centrum voor Wiskunde en Informatica (CWI)
References: 02-09-152
Keywords: parse, SQL
Posted-Date: 13 Oct 2002 16:03:10 EDT

GuaGuaHuang wrote:
> I am using yacc&lex to analysis a SQL batch. I only want to find out
> the SELECT statements in the batch and make some transformation to
> them. Other statements will not be changed.

In the following 2 papers a technique called "island grammars" is
described, it is used to parse only the statements in which you
are really interested. The rest of the text is parsed as a stream
of characters. This stream of unparsed characters can be considered
as water and the interesting statements as islands.

    author = "Leon Moonen",
    title = "Generating Robust Parsers using Island Grammars",
    year = 2001,
    month = oct,
    pages = "13-22",
    booktitle = "Proceedings of the 8th Working
                                    Conference on Reverse Engineering",
    publisher = "IEEE Computer Society Press",

    author = "Leon Moonen",
    title = "Lightweight Impact Analysis using Island Grammars",
    booktitle = "Proceedings of the 10th International
                                    Workshop on Program Comprehension (IWPC 2002)",
  publisher = "IEEE Computer Society Press",
  month = jun,
  year = "2002",

-- Mark

M.G.J. van den Brand,
Department of Software Engineering
Kruislaan 413, NL-1098 SJ AMSTERDAM, The Netherlands.

Tel___(+31) 20 5924213 WWW____
Fax___(+31) 20 5924199

Post a followup to this message

Return to the comp.compilers page.
Search the comp.compilers archives again.