PL/SQL programming in DB2

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Akaketwa
    #1

    PL/SQL programming in DB2

    Hi guys. i would like to develop functions and procedures to execute
    in db2 upon occurence of certain events within the stored data in db2.
    I understand Oracle databases have Procedural language extensions to
    Sql which makes this a lot easier. Is this also possible with db2.
    Anyone with links to threads or sites with explanations on how to
    program in db2 please assist

    Tags: None
    • Jeroen van den Broek
      #2
      Re: PL/SQL programming in DB2

      On May 8, 4:23 pm, Akaketwa <akake...@gmail .comwrote:
      Hi guys. i would like to develop functions and procedures to execute
      in db2 upon occurence of certain events within the stored data in db2.
      I understand Oracle databases have Procedural language extensions to
      Sql which makes this a lot easier. Is this also possible with db2.
      Anyone with links to threads or sites with explanations on how to
      program in db2 please assist
      In DB2-land it is called SQL PL.
      Following Google search will give you a lot of info on the IBM-site
      (including very good articles on its 'developerworks ' site:

      site:www.ibm.com db2 "sql pl" - Google Search
      http://www.google.com/search?hl=en&lr=&q=+site:www.ibm.com+db2+%22sql+pl%22


      If you're done reading these, you can remove the site-reference to get
      additional non-ibm info... ;-)

      HTH

      --
      Jeroen

        Comment

        • Jeroen van den Broek
          #3
          Re: PL/SQL programming in DB2

          On May 8, 4:51 pm, Jeroen van den Broek
          <nlt...@baasbov enbaas.demon.nl wrote:
          On May 8, 4:23 pm, Akaketwa <akake...@gmail .comwrote:
          >
          Hi guys. i would like to develop functions and procedures to execute
          in db2 upon occurence of certain events within the stored data in db2.
          I understand Oracle databases have Procedural language extensions to
          Sql which makes this a lot easier. Is this also possible with db2.
          Anyone with links to threads or sites with explanations on how to
          program in db2 please assist
          >
          In DB2-land it is called SQL PL.
          Following Google search will give you a lot of info on the IBM-site
          (including very good articles on its 'developerworks ' site:
          >
          http://www.google.com/search?hl=en&l...com+db2+%22sql...
          >
          If you're done reading these, you can remove the site-reference to get
          additional non-ibm info... ;-)
          >
          HTH
          >
          http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0412liu/


          is 'plugging' a book on DB2 SQL PL written by a team from the Toronto
          Lab, but also offers a free download of chapter2 of the book ('Basic
          SQL Procedure structure') and sample code.

          --
          Jeroen

            Comment

            • jefftyzzer
              #4
              Re: PL/SQL programming in DB2

              On May 8, 7:59 am, Jeroen van den Broek
              <nlt...@baasbov enbaas.demon.nl wrote:
              On May 8, 4:51 pm, Jeroen van den Broek
              >
              >
              >
              >
              >
              <nlt...@baasbov enbaas.demon.nl wrote:
              On May 8, 4:23 pm, Akaketwa <akake...@gmail .comwrote:
              >
              Hi guys. i would like to develop functions and procedures to execute
              in db2 upon occurence of certain events within the stored data in db2.
              I understand Oracle databases have Procedural language extensions to
              Sql which makes this a lot easier. Is this also possible with db2.
              Anyone with links to threads or sites with explanations on how to
              program in db2 please assist
              >
              In DB2-land it is called SQL PL.
              Following Google search will give you a lot of info on the IBM-site
              (including very good articles on its 'developerworks ' site:
              >
              http://www.google.com/search?hl=en&l...com+db2+%22sql...
              >
              If you're done reading these, you can remove the site-reference to get
              additional non-ibm info... ;-)
              >
              HTH
              >
              http://www-128.ibm.com/developerwork...rticle/dm-0412...
              >
              is 'plugging' a book on DB2 SQL PL written by a team from the Toronto
              Lab, but also offers a free download of chapter2 of the book ('Basic
              SQL Procedure structure') and sample code.
              >
              --
              Jeroen- Hide quoted text -
              >
              - Show quoted text -
              I can't say enough good things about the book Jeroen references. If
              you're going to write DB2 SPs, UDFs, or inline SQL PL (analogous to PL/
              SQL's anonymous blocks), it's indispensable.

              --Jeff

                Comment

                • --CELKO--
                  #5
                  Re: PL/SQL programming in DB2

                  >>I understand Oracle databases have Procedural language extensions to SQL which makes this a lot easier. <<

                  Oracle's PL/SQL is like, but not identical to, the Standard SQL/PSM.
                  Most of the time you can translate it easily (they use ":=" instead
                  of "SET.. =..", etc.) IBM is a pretty good implementation of the SQL/
                  PSM. For a good discussion and some details on procedural
                  extensions to SQL, get Jim Melton's book "understand ing SQL's Stored
                  Procedures" A Complete Guide to SQL/PSM" (ISVBN10" 1-555860-461-8)


                    Comment

                    Previous template Next
                    Working...