DB2 CONNECT / DB2CONNCT / B10 - DB2

.NET application using IBM .NET driver,  is getting "SQL30073N
0x2156 Parameter value 0x0000 is not supported" error when
fetching the result-set returned by the CALL statement against
IBM i Database. The said SP is returning the scrollable cursor,
hence the issue.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using IBM.Data.DB2;

namespace _64kissue
{
    class Program
    {
        static void Main(string[] args)
        {

            int i = 0;
            DB2Connection con = new
DB2Connection("Server=iseries.rs.com:446;Database=C700060x;User
ID=;pwd= ");
            if (con.IsOpen == false)
            {
                con.Open();
                Console.WriteLine("Connection opened");
            }
            DB2Command cmd = con.CreateCommand();
            cmd.CommandText = "proj4IBM.try_this_test";
            cmd.CommandType =
System.Data.CommandType.StoredProcedure;
            DB2DataReader reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                Console.WriteLine(reader.GetValue(0));
                Console.WriteLine("Record no: " + i++);
            }
        }
    }
}

****************************************************************
* USERS AFFECTED:                                              *
* DB2 .NET applications calling SP on IBM i.                   *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to DB2 version 11.1.5.5                              *
****************************************************************

NA

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

09.01.2019
23.02.2020
23.02.2020