Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Posts
    2

    Unanswered: Problem with "WLM ENVIRONMENT SAMP1" line

    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

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Exactly which error message did you get?
    Do you have WLM installed on your system? If not, then you can't use WLM.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •