class TestIbmDb2 < Test::Unit::TestCase

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

end

__END__
0:string
1:string
2:string
3:int
4:false

-----
0:int
1:string
2:int
3:string
4:int
5:real
6:real

-----
0:string
1:string
2:blob

-----
region:false
5:real