Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
4 replies Latest Post - ‏2012-05-23T17:46:05Z by Arvind_Gupta
SystemAdmin
SystemAdmin
2826 Posts
ACCEPTED ANSWER

Pinned topic How to call a Stored Procedure with array param from C#

‏2007-11-25T00:33:48Z |
Hello,
Is there a way from a C# application to call a stored procedure that takes an array input parameter?
The problem I am facing is that the DB2Parameter object only accepts objects types that come from
DB2Type enumeration, and it lacks an array type.

Note: that running the SP from a db2cmd works fine -> CALL PROCESS_LIST(ARRAY[);
Any suggestions?

References
I have executed the following
CREATE TYPE S_LIST AS CHAR(12) ARRAY[100];
then created a SP accordingly
CREATE PROCEDURE PROCESS_LIST(IN p_SLIST S_LIST)
.....
Updated on 2012-05-23T17:46:05Z at 2012-05-23T17:46:05Z by Arvind_Gupta
  • kanchana
    kanchana
    147 Posts
    ACCEPTED ANSWER

    Re: How to call a Stored Procedure with array param from C#

    ‏2007-11-25T06:19:43Z  in response to SystemAdmin
    We do not support array parameters currently. It is on our to-do list, but has not been committed to any particular release.

    Kanchana
    • SystemAdmin
      SystemAdmin
      2826 Posts
      ACCEPTED ANSWER

      Re: How to call a Stored Procedure with array param from C#

      ‏2007-11-26T06:11:28Z  in response to kanchana
      Well too bad...Thanks anyways
    • ada4ko
      ada4ko
      1 Post
      ACCEPTED ANSWER

      Re: How to call a Stored Procedure with array param from C#

      ‏2012-05-10T20:57:02Z  in response to kanchana
      Any changes to this?
      I want to call stored procedure with array parm as output.
      • Arvind_Gupta
        Arvind_Gupta
        58 Posts
        ACCEPTED ANSWER

        Re: How to call a Stored Procedure with array param from C#

        ‏2012-05-23T17:46:05Z  in response to ada4ko
        We do not support array parameters as output in stored procedure currently.