IBM Support

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

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • .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=<uid>;pwd= <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++);
                }
            }
        }
    }
    

Local fix

  • NA
    

Problem summary

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

Problem conclusion

  • DB2 v11.1 M5FP5 will contain the fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT27700

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-01-09

  • Closed date

    2020-02-23

  • Last modified date

    2020-02-23

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • RB10 PSY

       UP

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"11.1"}]

Document Information

Modified date:
03 September 2021