Results 1 to 14 of 14

Thread: DB2 Sprocs

  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: DB2 Sprocs

    Why doesn't IBM implement procedural internal sprocs? Do they all have to be external sprocs?

    What a royal pain
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Apr 2008
    Posts
    51
    You have the option of writing them in a REAL programming language - the way all stored procs should be done, in my opinion
    db2topgun.com

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    So T-SQL and PL-SQL are not "real" programming languages?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by SuperKuper
    You have the option of writing them in a REAL programming language - the way all stored procs should be done, in my opinion
    BAL ?

    -PatP

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by Pat Phelan
    BAL ?

    -PatP

    Never had the pleasure

    http://en.wikipedia.org/wiki/IBM_Bas...embly_language
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Apr 2008
    Posts
    51
    Quote Originally Posted by Brett Kaiser
    So T-SQL and PL-SQL are not "real" programming languages?

    Not even close
    db2topgun.com

  7. #7
    Join Date
    Apr 2008
    Posts
    51
    Quote Originally Posted by Pat Phelan
    BAL ?

    -PatP
    IBM's 370 Assembler (aka Basic Assembler Language or BAL) is one of them. There are also a number of 3rd generation languages in which DB2 UDFs and stored procedures can be written, e.g. COBOL, C, FORTRAN, PL/I, etc.
    db2topgun.com

  8. #8
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    DB2 stored procedures can be written in the standard-compliant SQL PL dialect. So the question would rather be: why are you still sticking to an older DB2 version that does not have this feature yet?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Such as?

    What version are you talking about?

    I'm on Big Iron, and hell we're just getting off 7.2
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  10. #10
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    I don't know if DB2 for iSeries has it, but DB2 z/OS and DB2 LUW have both SQL PL support in stored procs. I believe this was introduced in DB2 z/OS V8 - and even earlier in DB2 LUW.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  11. #11
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Got any samples?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  12. #12
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Brett Kaiser
    Got any samples?
    http://publib.boulder.ibm.com/infoce.../r_samples.htm
    ---
    "It does not work" is not a valid problem statement.

  13. #13
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    That's what I wanted to say too: just look at the manual.
    http://publib.boulder.ibm.com/infoce...esqlnative.htm
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  14. #14
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    OK, but in the example, in the SQL Sproc, I don't see any procedural code
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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