Thread: SQL-Standard???

    #1
  1. Cobol Victim
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2002
    Location
    Munich, GER
    Posts
    124
    Rep Power
    13

    SQL-Standard???


    Hi there!
    I'm now working with Db2 now and found tons of new SQL commands.
    But the problem is:
    Some db2 SQL statements aren't available in mysql/Oracle ... and vice versa.
    So i wondered where i can find a list of SQL commands that are available in all databases.


    TIA
    Lebowski: Isn't that what makes a man?
    Dude: Mmm, sure. That and a pair of testicles.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    Paris Uppland
    Posts
    2,376
    Rep Power
    391
    The problem with SQL is that almost all vendors add extensions and only implements a subset of ANSI SQL 99. Especially Mysql lacks a large amount of features that is part of the standard.

    You can check that your queries are ANSI SQL 99 compliant by using the validator at

    http://developer.mimer.se/validator/parser99/index.tml

    Even if your queries adheres to standard there is no warranty that they are portable between different DBMS.
  4. #3
  5. Cobol Victim
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2002
    Location
    Munich, GER
    Posts
    124
    Rep Power
    13

    Argg


    Hm yeah that was my guess to.
    The tool you mentioned is geat but our Db2 (Os390) does not like Functions like ADD, which even complie with Ansi 92.

    Regards
    Lebowski: Isn't that what makes a man?
    Dude: Mmm, sure. That and a pair of testicles.

IMN logo majestic logo threadwatch logo seochat tools logo