native db2 Stored procedures on Mainframes

HABBIE · New User Joined: 08 Jul 2014 Posts: 24 Location: INDIA

Hi,

I am very new to Mainframes . I am an AS400 developer. I am connecting to mainframe server through IBM Data studio & trying to create a stored procedure.

CREATE PROCEDURE FIRST_PROCEDURE ()
RESULT SETS 1
LANGUAGE SQL
FENCED
COLLID TEST
WLM ENVIRONMENT WLMENV1
RUN OPTIONS 'NOTEST(NONE,*,*,*)'
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 :
M1.FIRST_PROCEDURE - Deploy started.
Calling the build utility ...
[jcc][1085][10939][4.17.30] Invalid CALL syntax. ERRORCODE=-4463, SQLSTATE=42601
M1.FIRST_PROCEDURE - Deploy failed.

I dont know what I m missing here. can someone kindly help me with this.

Rohit Umarjikar · Posted: Fri Aug 07, 2015 12:39 am

Show us the CALL statement or how are you calling it?

HABBIE · New User Joined: 08 Jul 2014 Posts: 24 Location: INDIA

This error is during compillation.