In this article I talk about using SQL joins to reduce calls to the data server.
https://www.db2expert.com/db2expert/db2-sql-and-application-performance-part-2-using-sql-joins-to-reduce-calls-to-the-data-server/
Cheers,
Dan Luksetich