The methods described in "Using Arrays to Input Parameter Values" and "Retrieving a Result Set into an Array" use compound SQL to optimize the network flow.
Use these methods as much as possible.
[ DB2 List of Books | Search the DB2 Books ]