I want to use the following 2 SQL statements in 1 RPG program and have the results print out. How can i accomplish this task? Not sure how to do even 1 SQL statement and have it print, let alone 2.
Select RNSREGN region, COUNT(RNSINVN) #Orders, SUM(RNSQTY) #Books, SUM(RNSTOT$) $$ from WFILES.RNSORDP WHERE RNSREGN > 0 GROUP BY "RNSREGN"
Select BOHREGN region, COUNT(BOHINVN) #Orders, SUM(BOHQTY) #Books, SUM(BOHDTTOT) $$ from WFILES.BOHEDR WHERE BOHREGN > 0 GROUP BY "BOHREGN"
September 21, 2012 3:30 PM