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	6	0	1251
	NUMBER	IN	CHARACTER	6	0	1251
	SALARY	BEFORE CASTING	DOUBLE	8	0	0
	DEPT	BEFORE CASTING	CHARACTER	3	0	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