The UNIX and Linux Forums  


Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
.
google unix.com




View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #2 (permalink)  
Old 10-03-2007
porter porter is offline Forum Advisor  
Registered User
  
 

Join Date: Jan 2007
Posts: 2,965
Case 5132 gets returned twice by your first select because it's in two rows.

Then in the state select, two states get returned because there are two states associated with 5132.

I suggest doing something like....

Code:
db2 -x ..... | while read A B C D
do
....
done