class TestIbmDb2 < Test::Unit::TestCase

  def test_125
    assert_expect {
      conn = DB2::connect db,user,password
      result = DB2::exec conn, "select * from sales"
      result2 = DB2::exec conn, "select * from staff"
      for i in (0 ... DB2::num_fields(result))
        puts "#{i}:#{DB2::field_name(result,i)}"
      end
      
      puts "\n-----"
      for i in (0 ... DB2::num_fields(result2))
        puts "#{i}:#{DB2::field_name(result2,i)}"
      end
      
      puts "\n-----"
      puts "Region:#{DB2::field_name(result,'REGION')}"
      puts "5:#{DB2::field_name(result2,5)}"
    }
  end

end

__END__
0:SALES_DATE
1:SALES_PERSON
2:REGION
3:SALES

-----
0:ID
1:NAME
2:DEPT
3:JOB
4:YEARS
5:SALARY
6:COMM

-----
Region:REGION
5:SALARY