ProTech-Online.com

IBM DB2 SQL code example to pull Quantus bill to name.

CREATE FUNCTION TEST_GET_BILLING_NAME( BILLBRANCH VARCHAR(8), BILLACCT VARCHAR(8) )
    RETURNS VARCHAR(32)
    SPECIFIC GET_BILLING_NAME
    LANGUAGE SQL
    READS SQL DATA
    NO EXTERNAL ACTION
    RETURN
       SELECT QUANTUS.CUSTOMER.NAME1
       FROM QUANTUS.CUSTOMER
       WHERE QUANTUS.CUSTOMER.BRANCH = BILLBRANCH AND
           QUANTUS.CUSTOMER.CUSTOMERACCT = BILLACCT