Properties

Name: BONUS_INCREASE 
Schema: USER 
Definer: USER 
Specific name: BONUS_INCREASE 
Valid:  
Create time: 24.06.2006 
Alter time: 24.06.2006 
Determenistic:  
Language: SQL 
Qualifier: USER 
Description:  

Parameters

Name Direction Type Length Scale Codepage Description
  P_BONUSFACTOR  IN  DECIMAL   
  P_BONUSMAXSUMFORDEPT  IN  DECIMAL   
  P_DEPTSWITHOUTNEWBONUSES  OUT  VARCHAR  255  1251   
  P_COUNTDEPTSVIEWED  OUT  INTEGER   
  P_COUNTDEPTSBONUSCHANGED  OUT  INTEGER   
  P_ERRORMSG  OUT  VARCHAR  255  1251   
Total: 6 parameter(s)

Depend on objects

Name
  USER.P4434996 
Total: 1 object(s)

Autherisations

Grantor Grantee Authorities
  SYSIBM  USER  EXECUTE=HELD_GRANTABLE 
Total: 1 autherisation(s)

SQL

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

See Also

List of procedures