suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT27700 Status: Geschlossen

WHEN CALLING EXTERNAL STORED PROCEDURE AGAINST IBM I SERVER, APPTHROWS
EXCEPTION : SQL30073N PARAMETER VALUE IS NOT SUPPORTED

Produkt:
DB2 CONNECT / DB2CONNCT / B10 - DB2
Problembeschreibung:
.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++);
            }
        }
    }
}
Problem-Zusammenfassung:
****************************************************************
* USERS AFFECTED:                                              *
* DB2 .NET applications calling SP on IBM i.                   *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to DB2 version 11.1.5.5                              *
****************************************************************
Local-Fix:
NA
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
09.01.2019
23.02.2020
23.02.2020
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version