MVSFORUMS.com

[vijay]

Hi,
I've to selectively unload data for around 50k accounts from a huge DB2 table. I have the 50k accounts in another DB2 table as well as flat file
Which is a recommended approach to do this

- SQL join between two tables
- Unload the big table to a flat file and do a SORT joinkeys between the two flat files

Thanks,
Vijay

[kolusu]

vijay,

Do you indexes on the keys to be matched for both tables? If you have it then a SQL JOIN on both tables might be good.

If you do NOT have indexes defined, then you are better off unloading both tables to flat files and then run Joinkeys

While unloading make sure you ONLY unload the relevant fields necessary.
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu

[vijay]

Thank you Kolusu. Majority of the files are using Indexes. I will try both and see the results on one file

Vijay