Properties

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

Parameters

Name Direction Type Length Scale Codepage Description
  EMPNO  BEFORE CASTING  CHARACTER  1251   
  NUMBER  IN  CHARACTER  1251   
  SALARY  BEFORE CASTING  DOUBLE   
  DEPT  BEFORE CASTING  CHARACTER  1251   
Total: 4 parameter(s)

SQL

CREATE FUNCTION resign_employee (number CHAR(6))
RETURNS TABLE (empno  CHAR(6),
salary DOUBLE,
dept   CHAR(3))
MODIFIES SQL DATA
LANGUAGE SQL
BEGIN ATOMIC
DECLARE l_salary DOUBLE;--
DECLARE l_job CHAR(3);--


RETURN VALUES (number,l_salary, l_job);--


END

See Also

List of functions