Hi to all !!! And thanks to answer my topics.
I have problems when I try of run stored procedures, show diferents
errors. I made one test with one example of the tutorials. The example
is this
CREATE PROCEDURE RETURN_DEPT_SAL ARY
(IN DEPT_NUMBER CHAR(3),
OUT DEPT_SALARY DECIMAL(15,2),
OUT DEPT_BONUS_CNT INT)
LANGUAGE SQL READS SQL DATA
P1: BEGIN
DECLARE EMPLOYEE_SALARY DECIMAL(9,2);
DECLARE EMPLOYEE_BONUS DECIMAL(9,2);
DECLARE TOTAL_SALARY DECIMAL(15,2)DE FAULT 0
DECLARE BONUS_CNT INT DEFAULT 0;
DECLARE END_TABLE INT DEFAULT 0;
DECLARE C1 CURSOR FOR
SELECT SALARY, BONUS FROM RJOHNSON.EMPLOY EE
WHERE WORKDEPT = DEPT_NUMBER;
DECLARE CONTINUE HANDLER FOR NOT FOUND
SET END_TABLE = 1;
DECLARE EXIT HANDLER FOR SQLEXCEPTION
SET DEPT_SALARY = NULL;
OPEN C1;
FETCH C1 INTO EMPLOYEE_SALARY , EMPLOYEE_BONUS;
WHILE END_TABLE = 0 DO
SET TOTAL_SALARY = TOTAL_SALARY + EMPLOYEE_SALARY +
EMPLOYEE_BONUS;
IF EMPLOYEE_BONUS 0 THEN
SET BONUS_CNT = BONUS_CNT + 1;
END IF;
FETCH C1 INTO EMPLOYEE_SALARY , EMPLOYEE_BONUS;
END WHILE;
CLOSE C1;
SET DEPT_SALARY = TOTAL_SALARY;
SET DEPT_BONUS_CNT = BONUS_CNT;
END P1;
And show between others message like these
DECLARE EMPLOYEE_SALARY DECIMAL(9,2)
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0104N An unexpected token "END-OF-STATEMENT" was found following
"_SALARY
DECIMAL(9,2)". Expected tokens may include: "<psm_semicolon >". LINE
NUMBER=7. SQLSTATE=42601
DECLARE EMPLOYEE_BONUS DECIMAL(9,2)
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0104N An unexpected token "DECLARE EMPLOYEE_BONUS DECIMAL" was
found
following "BEGIN-OF-STATEMENT". Expected tokens may include:
"<values>".
SQLSTATE=42601
If I change the ";" for "," show others messages
I made stored procedure but show same messages.
Somebody know what is the problem?
Of new thanks to all for answer
Iván
