IBM DB2 SQL code example to pull Quantus standard employee information.

CREATE FUNCTION CHAD_TEST_EMPLOYEE_STD( C_BRANCH VARCHAR(8), C_OBJECTNO BIGINT )
    RETURNS VARCHAR(60)
    SPECIFIC TEST_EMPLOYEE_FL
    LANGUAGE SQL
    READS SQL DATA
    NO EXTERNAL ACTION
BEGIN ATOMIC
    DECLARE tmpString VARCHAR(60) DEFAULT '';
    SET tmpString = (SELECT CONCAT(CONCAT(RTRIM(QUANTUS.EMPLOYEE.NAME2), ' '), QUANTUS.EMPLOYEE.NAME1)
       FROM QUANTUS.EMPLOYEE
    WHERE QUANTUS.EMPLOYEE.BRANCH = C_BRANCH
       AND QUANTUS.EMPLOYEE.OBJECTNO = C_OBJECTNO FETCH FIRST 1 ROW ONLY);
    RETURN tmpString;

END