Hi,
I have a new task where i have two tables
Acct_ open and lookup table

In the Acct_open table there is all the information about an account including account number
and lookup table is having a country code and corresponding country name where that account has been opened.

both tables are connected with each other with country code as in the Acct_open table first three digits in the account number represents country code.

For e.g.
In Acct_open Table,

account number
300456728
200846745
101758599
-
-
-

and in the lookup table,
Country code country name
300 Singapore
200 Canada
101 US
201 India



now what i need to do is to scan each record in Acct_open table and check the corresponding country name, fetch that record and put into other directory, having same name as country name, in the form of sequential file.


Can anybody help me with this ASAP.


Thanks