Hello,

I need an help with retrving results from a stored procedure, I need to correct the syntax which I am not able to get through

Given below are 3 commads, here 1) and 2) works fine, my problem is I need 3) to work fine too.

1) create table emp1 (empno int,SALARY int) (works fine)
2) CREATE PROCEDURE UPDATE_SALARY_10 (IN EMPLOYEE_NUMBER int,IN RATE int) LANGUAGE SQL MODIFIES SQL DATA UPDATE EMP1 SET SALARY = SALARY * RATE WHERE EMPNO = EMPLOYEE_NUMBER (works fine)
3) CREATE PROCEDURE dd (OUT result int) LANGUAGE SQL CONTAINS SQL select empno from emp1 (gives 104 error)

Can someone please help me here, I know its a syntax error but I am not able to get through it.

Thank you
Ashok

Try the following instead:Also make sure that you don't get a -811 at runtime! (In this particular example, the table emp1 should have exactly one row.)

Thank you very much Peter, it helped
This is the command I used and it helped

CREATE PROCEDURE dd (OUT result int) LANGUAGE SQL READS SQL DATA select empno into result from emp1 where empno=1