Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    13

    Unanswered: Call SP from a Cobol-Db2-Cics program

    Hi all,

    I have a Cobol-DB2-Cics program that Invokes a DB2 Stored procedure in cobol in another DB2 subsytem. I am getting a sqlcode - 471 on the SQL CALL SP statement.

    -471 INVOCATION OF FUNCTION OR PROCEDURE name FAILED DUE TO REASON rc

    Can anyone please throw some light on this issue ? This has become a show stopper for my present activity.

    Thanks in anticipation
    Thanks
    Ranjith

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You need to get the Reason Code and look in the Messages and Codes manual.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2003
    Location
    India
    Posts
    13
    [Thxs for the reply.

    I tracked the return code. It is 00E7900C.
    "The WLM application environment name specified for the
    user-written routine is not defined or is currently not available for DB2
    use in the active WLM policy."

    Here it is mentioning that the WLM is defined or active. But we are executing in SPAS environment.

    Thats what really confusing. I have no clue..

    Pls suggest.

    Thxs
    Thanks
    Ranjith

  4. #4
    Join Date
    Aug 2003
    Location
    India
    Posts
    13
    [Thxs for the reply.

    I tracked the return code. It is 00E7900C.
    "The WLM application environment name specified for the
    user-written routine is not defined or is currently not available for DB2
    use in the active WLM policy."

    Here it is mentioning that the WLM is defined or active. But we are executing in SPAS environment.

    Thats what really confusing. I have no clue..

    Pls suggest.

    Thxs
    Thanks
    Ranjith

  5. #5
    Join Date
    Oct 2003
    Location
    San Antonio, Texas
    Posts
    4

    Smile

    Look in your Create Procedure statements.
    It will either have a statement

    NO WLM ENVIRONMENT

    or

    WLM ENVIRONMENT <Name of WLM>

Posting Permissions

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