
ProTech-Online.com
IBM DB2 SQL code example to pull Quantus customers.
CREATE PROCEDURE TEST_CUSTOMERS
( )
SPECIFIC CUSTOMERS
DYNAMIC RESULT SETS 1
LANGUAGE SQL
BEGIN
DECLARE cursor1 CURSOR WITH RETURN TO CLIENT FOR
SELECT * FROM QUANTUS.CUSTOMER
ORDER BY QUANTUS.CUSTOMER.CUSTOMERACCT;
OPEN cursor1;
END
Copyright © 2013 ProTechs-Online.com; All rights reserved.