Dear Ones

I have created belowmentioned routine using DB2 v9.1 LUW

CREATE PROCEDURE UPDATE_SALARY
(IN EMPLOYEE_NUMBER CHAR(10),
IN RATE DECIMAL(6,2))
LANGUAGE SQL
WLM ENVIRONMENT SAMP1
COMMIT ON RETURN YES
IF RATE <= 0.50
THEN UPDATE EMP
SET SALARY = SALARY * RATE
WHERE EMPNO = EMPLOYEE_NUMBER;
ELSE UPDATE EMP
SET SALARY = SALARY * 0.50
WHERE EMPNO = EMPLOYEE_NUMBER;
END IF
And getting the error on below mentioned lines. Could u please tell me what was wrong in the code

WLM ENVIRONMENT SAMP1
COMMIT ON RETURN YES

I would like to know the usage of WLM ENVIRONMENT

Note: Code execution is fine, after removing the two line

Regards
Ramesh

Exactly which error message did you get?
Do you have WLM installed on your system? If not, then you can't use WLM.