Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2014
    Posts
    294

    Unanswered: SQLCODE=-206, SQLSTATE=42703 native stored procedure on Db2 Z/OS

    Hi,

    I have connected to the mainframe machine to IBM Data studio.

    I want to create a native Db2 sql stored procedure on Db2 Z/OS server.This is the code :

    --------
    CREATE PROCEDURE PROCEDURE1 ()
    VERSION V1
    ISOLATION LEVEL CS
    RESULT SETS 5
    LANGUAGE SQL
    P1: BEGIN
    -- Declare cursor
    DECLARE cursor1 CURSOR WITH RETURN FOR
    SELECT NAME FROM SYSIBM.SYSTABLES;
    -- Cursor left open for client application
    OPEN cursor1;
    END P1

    error :
    Deploy MTYUE.PROCEDURE1

    Running
    MTYUE.PROCEDURE1 - Deploy started.
    DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=VERSION , DRIVER=4.17.30
    MTYUE.PROCEDURE1 - Deploy failed.
    MTYUE.PROCEDURE1 - Roll back completed successfully.

    OS : Windows ,IBM data studio connectivity .

    I don't know where i am going wrong. Can someone kindly help me , what i have to do ?
    Last edited by HABBIE; 08-10-15 at 06:28.

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
  •