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 UNIX Forums - Click on the Thread or Permalink to View Entire Thread -->
  #2 (permalink)  
Old 10-03-2007
porter porter is offline
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
Reply With Quote