View previous topic :: View next topic
|
Author |
Message |
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. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
Show us the CALL statement or how are you calling it? |
|
Back to top |
|
|
HABBIE
New User
Joined: 08 Jul 2014 Posts: 24 Location: INDIA
|
|
|
|
This error is during compillation. |
|
Back to top |
|
|
|