I have a simple script which returns me the response from a table.

while read -r xx
do
db2 -x "select * from Table where user ='$xx' with ur " >> "/home/Results.txt"
done < "/home/USERS.txt"

do
db2 -x "select * from Table where user ='$xx' and client = '$yy' with ur " >> "/home/Results.txt"
done < "/home/USERS.txt"

Same file with delimiters:

while IFS="," read VAR1 VAR2 THEREST
do
        ...
done < inputfile

exec 5<file1 # Open file into FD 5
exec 6<file2

while read VAR1 <&5 && read VAR2 <&6
do
        ...
done

exec 5<&- # Close FD 5
exec 6<&-

while ...
do
...
done > results.txt

Sanjeev,
You have posted the same question to two different forums and received different answers to your posts. You shouldn't post to multiple locations because the responses to your posts will likely not realize that two conversations are going on for this single topic.

Please don't do this again in the future. Please ask the administrators to merge these two discussions into a single thread and to close the other one!

I tried running the below script but it doesn't work for me....can you fix this for me....Sorry, I am new to unix..

exec 5< "/home/epprod/COSMOS_CUSTOME_CLIENTID.txt"
exec 6< "/home/epprod/COSMOS_CUSTOME_CLIENTIDS.txt"
while read VAR1 <&5 && read VAR2 <&6
do
db2 -x "select customer_nbr,client_id from policies where customer_nbr='VAR1' and client_id='VAR2' with ur " >> "/home/epprod/COSMOS_CUSTOME_CLIENTID_Results.txt"
done
exec 5<&-
exec 6<&-

You are one infraction away from being set read-only for a while, please listen to the messages and warnings we're giving you. Don't double-post, be sure to code-tag your posts, and do NOT pm people with technical questions or to 'hurry them up'. We are not on call.

while read VAR1 <&5 && read VAR2 <&6
do
db2 -x "select customer_nbr,client_id from policies where customer_nbr='$VAR1' and client_id='$VAR2' with ur " 
done > "/home/epprod/COSMOS_CUSTOME_CLIENTID_Results.txt"