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"
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!