Shell Programming and Scripting

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

By table, you mean a database table? You need to write a join in SQL.

ok...yeah i know that i need to write a join SQL query....but how to put that data into corresponding files depending on the country name.now suppose i have following code for my script:

while read Record1
do
SQLQuery=`echo $Record1 | awk '{printf $0 }'`

db2 " export to SrcRejData.tmp of del $SQLQuery" > $workfile

done
now in this file i have all the records in a temporary file SrcRejData.tmp, including all the records from Acct_open table and Country name from lookup table
is there any way if i can now scan SrcRejData.tmp to fetch the records according to country names and put them into corresponding sequential file