MQSeries.net :: View topic - Creating a sample stored procedure to use with MQListener

najafi1977

hi
i use WebSphere MQ with DB2
and i do whole steps in the ibm's book "application programming and sql guide" to use mqlistener.but when i want to create a sample stored procedure to use with mqlistener(APROC) according to the instruction i get a error:
this command is:
CREATE PROCEDURE TEST.APROC (
IN PIN VARCHAR(25),
OUT POUT VARCHAR(2))
LANGUAGE SQL
FENCED
NOT DETERMINISTIC
NO DBINFO
COLLID TESTLSRN
WLM ENVIRONMENT TESTWLMX
ASUTIME NO LIMIT
STAY RESIDENT NO
PROGRAM TYPE MAIN
SECURITY USER
PROCEDURE1: BEGIN
INSERT INTO PROCTABLE VALUES(PIN); SET POUT= 'OK';
END PROCEDURE1

when i run this syntax,the following error is appear:
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "<END-OF-STATEMENT>". SOME
SYMBOLS THAT MIGHT BE LEGAL ARE: ;
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 502 0 0 -1 1050 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'000001F6' X'00000000' X'00000000' X'FFFFFFFF'
X'0000041A' X'00000000' SQL DIAGNOSTIC INFORMATION
please tell me how can i solve this problem.
regards
N.Najafi