class TestIbmDb2 < Test::Unit::TestCase

  def test_153
    assert_expect {
      conn = DB2::connect db,username,password
      result = DB2::exec conn, "select * from org"
      while (row = DB2::fetch_assoc(result))
      printf("%4d ",row['DEPTNUMB'])
      printf("%-14s ",row['DEPTNAME'])
      printf("%4d ",row['MANAGER'])
      printf("%-10s",row['DIVISION'])
      printf("%-13s ",row['LOCATION'])
      puts ""
      end
    }
  end

end

__END__

  10 Head Office     160 Corporate New York      
  15 New England      50 Eastern   Boston        
  20 Mid Atlantic     10 Eastern   Washington    
  38 South Atlantic   30 Eastern   Atlanta       
  42 Great Lakes     100 Midwest   Chicago       
  51 Plains          140 Midwest   Dallas        
  66 Pacific         270 Western   San Francisco 
  84 Mountain        290 Western   Denver