I have a requirement, in that I have to extarct the data from 7 tables.
Here I have 2 options, I can write a DB2 Join query or write a COBOL program (First I will fetch the records from one table and then from the result of fisrt query need to fetch the data from 2nd table...so on till 7th table)
Perfromance wise which is better?
I am going to join the tables on indexed colmns only.
1) You can go for the DB2 unload utilities
2) Or if you have the load files for these tables then use SORT JOINKEY's instead of DB2 ( Best in performance)