I have a table which has the following columns.
Account holder name
Say, Under a branch there might be 1 lakh accounts and there might be some 300 branches. Now, I want all the account details under some 50 branches(input in a file). I have two options.
a) Unload all the accounts from the table and extract only the accounts which are under given 50 branches(50 lakh accounts) through file processing
b) Retrieve the data through DB2 cursor.
Which one would be advisable.