BONUS_INCREASE |
USER |
USER |
BONUS_INCREASE |
|
24.06.2006 |
24.06.2006 |
|
SQL |
USER |
|
|
P_BONUSFACTOR |
IN |
DECIMAL |
3 |
2 |
0 |
|
|
P_BONUSMAXSUMFORDEPT |
IN |
DECIMAL |
9 |
2 |
0 |
|
|
P_DEPTSWITHOUTNEWBONUSES |
OUT |
VARCHAR |
255 |
0 |
1251 |
|
|
P_COUNTDEPTSVIEWED |
OUT |
INTEGER |
4 |
0 |
0 |
|
|
P_COUNTDEPTSBONUSCHANGED |
OUT |
INTEGER |
4 |
0 |
0 |
|
|
P_ERRORMSG |
OUT |
VARCHAR |
255 |
0 |
1251 |
|
Total: 6 parameter(s)
|
USER.P4434996 |
Total: 1 object(s)
|
SYSIBM |
USER |
EXECUTE=HELD_GRANTABLE |
Total: 1 autherisation(s)
CREATE PROCEDURE bonus_increase (IN p_bonusFactor
DECIMAL (3,2), IN p_bonusMaxSumForDept DECIMAL
(9,2), OUT p_deptsWithoutNewBonuses VARCHAR(255),
OUT p_countDeptsViewed INTEGER,
OUT p_countDeptsBonusChanged INTEGER,
OUT p_errorMsg VARCHAR(255)) SPECIFIC BONUS_INCREASE
LANGUAGE SQL
DYNAMIC RESULT SETS 1
BEGIN
DECLARE v_dept, v_actdept CHAR(3);--
DECLARE v_bonus, v_deptbonus, v_newbonus DECIMAL(9,2);--
DECLARE v_empno CHAR(6);--
DECLARE v_atend SMALLINT DEFAULT 0;--
RETURN -1;--
END
List of procedures