Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008

    Unanswered: Is any equilant for Varray (as it in ORACLE ) in DB2

    Hello all,

    I am new to DB2,Is any equilant for Varray (as it in ORACLE ) in DB2 I am using DB2 8.2.
    I have googled and found that we can use Global temprory tables insted.Can i retun table from stored procedure as OUT parameter.

    Avinash Byalihal

  2. #2
    Join Date
    May 2003
    You can return a result set from a stored procedure. It is not specified in the out paramters, but is defined a cursor with return. You can have multiple cursors with return if needed.

    Arrays are not available in 8.2, but I think it may be available in 9.5 (just released), or if not in 9.5 it is slated for the next release.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2007
    Jena, Germany
    ARRAYs are in 9.5.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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