Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Parsing BNF syntax diagrams..

by Solo (Deacon)
on Aug 20, 2004 at 15:23 UTC ( #384622=note: print w/replies, xml ) Need Help??


in reply to Parsing BNF syntax diagrams..

DB2 claims to be SQL-92 compliant. There are several ANSI SQL-92 BNF definitions out there. It might be reasonable to start with one of those and add the additional features of the DB2 implementation as you bump into them.

--Solo

--
You said you wanted to be around when I made a mistake; well, this could be it, sweetheart.

Replies are listed 'Best First'.
Re^2: Parsing BNF syntax diagrams..
by dragonchild (Archbishop) on Aug 20, 2004 at 15:27 UTC
    Of the top 100 RDBMS's by usage, I have heard of a single one that is truly SQL-92-compliant (or SQL-99-compliant, for that matter). Some are more compliant than others, but that's almost a matter of taste vs. compliance.

    ------
    We are the carpenters and bricklayers of the Information Age.

    Then there are Damian modules.... *sigh* ... that's not about being less-lazy -- that's about being on some really good drugs -- you know, there is no spoon. - flyingmoose

    I shouldn't have to say this, but any code, unless otherwise stated, is untested

      Well, I said 'claims to be compliant' for that reason.

      At any rate, it seems no more difficult to me to adjust the BNF for SQL-92 than to create the BNF from the diagrams IBM provides. In one case you'd need to test thoroughly to find all the DB2 statements not in the standard or redefined for DB2, on the other you'd need to make sure you'd parsed the diagrams into BNF correctly.

      --Solo

      --
      You said you wanted to be around when I made a mistake; well, this could be it, sweetheart.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://384622]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (7)
As of 2019-08-21 09:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?