Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2017
    Posts
    1

    Unanswered: SQL Error 30073 when calling a Stored Procedure from a different database using COBOL

    Hi,

    A call of a stored procedure from another database is successful using the DB2 database. A three part name is defined in order to call the Stored Procedure. Below is a sample:

    CALL DB1.SCHEMA1.TEST_SP('abc');


    A local call of a stored procedure using COBOL is also successful, as well as calling the procedure from the same database but a different schema:

    EXEC SQL
    CALL TEST_SP('abc');
    END-EXEC

    EXEC SQL
    CALL SCHEMA2.TEST_SP('abc');
    END-EXEC


    However, upon calling a stored procedure in another database using COBOL, generates a DB2 SQL Error with error code 30073. Below is a sample:

    EXEC SQL
    CALL DB1.SCHEMA1.TEST_SP('abc');
    END-EXEC


    SQL Error code 30073 is as follows:
    -30073 parameter subcode PARAMETER VALUE NOT SUPPORTED ERROR
    Explanation
    The specified parameter value is not supported by either the local DB2 or the remote server.


    Anyone can help with this error code?

    Thanks!

  2. #2
    Join Date
    Apr 2012
    Posts
    1,143
    Provided Answers: 27
    Follow the suggestions in the documentation for your version of DB2 and your operating-system platform for SQL30073N
    Determine what's different about the two databases, and give more facts about DB2-versions and operating system on which the DB2-server is running.

  3. #3
    Join Date
    Oct 2007
    Posts
    161
    Provided Answers: 9
    my first thought is different CCSID along the way?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •