Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006
    Posts
    1

    Unanswered: Passing record sets to DB2 stored procs

    Hi all,

    Can we pass record sets as input parameters to SQL stored procedures?

    Thanks and regards,
    Deepak

  2. #2
    Join Date
    Jan 2004
    Posts
    49
    Quote Originally Posted by deepak.pandit
    Hi all,

    Can we pass record sets as input parameters to SQL stored procedures?

    Thanks and regards,
    Deepak
    Yes, u can pass with column delimiter and record delimiter.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You can INSERT the reocrds into a Declared Global Temp table before calling the SP and read the records inside the SP

    HTH

    Sathyaram

    Quote Originally Posted by deepak.pandit
    Hi all,

    Can we pass record sets as input parameters to SQL stored procedures?

    Thanks and regards,
    Deepak
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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