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 |