ProTech's home page

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.