I have two batch jobs executing Db2 queries
1. The first query:
Select * from TABLE where COLUMN_NAME IN (value1,value2,value3,.....valueN)
2. The Second query:
Select * from TABLE where COLUMN_NAME = value1.
Now am running the First query using normal batch job.
The second query am running through java invoked by batch job, where am executing the second query by passing the COLUMN_NAME value and executes the query N times to get the same output as the First query.
Now here i want to know which one performs better ? The normal batch job or the java job executing the Db2 query N times.
Thanks In advance.
Proud z/OS USER