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

    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.





    Regsrds
    Avinash Byalihal

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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
    Location
    Jena, Germany
    Posts
    2,721
    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
  •