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

    Unanswered: How to pass an Array into a Stored Procedure ???

    Hi ,

    I have to write a stored procedure which would accept an array as an input parameter. But since there is no Array datatype available in db2 till Ver 9.5, is there any workaround that i can use ??? How would i be able to take in the parameters and run a loop like in C using a DB2 stored proc ....??? Is it possible at all ?? If so an example of how to do it would be fantastic ..

    Any help in this regard is deeply appreciated ...

    Last edited by Libin B; 01-17-08 at 09:58.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    Your only alternative is to store the values in a table or temp table and have the SP fetch the values in your loop.


Posting Permissions

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