ProTech's home page

ProTech-Online.com

IBM DB2 SQL code example to pull Quantus employee information.

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

END



Copyright © 2013 ProTechs-Online.com; All rights reserved.