SQL: Significant unsupported features

  • Embedded SQL
    • SQL99 requires Embedded SQL support for Ada, COBOL, Fortran, MUMPS, Pascal, PL/I

  • Privileges
    • Privileges on UPDATE, REFERENCES at column level
    • WITH GRANT OPTION argument to GRANT

  • Cursors
    • positioned UPDATE and DELETE

  • Transactions
    • Support for READ ONLY, READ UNCOMMITTED, READ REPEATABLE isolation levels

  • Basic query specification
    • Support for WITH RECURSIVE (heirarchical joins)

  • Triggers
    • Column specific triggers
    • Statement specific triggers
    • Time of creation trigger firing order

  • Error handling
    • SQLSTATE, SQLCODE, GET DIAGNOSTISTICS

  • Informational schema
Prev

Next

Page 25