Results 1 to 4 of 4

Thread: SQL used in Db2

  1. #1
    Join Date
    Jan 2003
    Posts
    35

    Unanswered: SQL used in Db2

    In Oracle stored procededures/queries the SQL used is PL/SQL. What do we call the SQL used in DB2 on WIndows/Linux/Unix?
    It has some different ways of doing things
    for eg.
    The function NVL in PL/SQL is replaced by coalesce in DB2.
    The method of writting recursive queries in Db2 (With...)is different from PL/SQL (Connect by prior)

    So what exactly is this SQL Syntax called?

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    sql

    each supplier tries to stick to a certain standard (ansi/sql.....)
    there are specific functions (not part of sql) available in each rdb that can do the same but have different names/syntax.
    sql used in stored procedures is : sql procedure language sql/pl based on SQL
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Jan 2003
    Posts
    35
    I read in some document that db2 uses Sql1999 std. Is this the same as the sql/PL standard mentioned by you?

  4. #4
    Join Date
    Jun 2006
    Posts
    471

    sqlpl

    sql/pl is just a procedure language that will use SQL
    because sql is just select/update/insert... and not programming language as SQL/PL
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •