require 'ibm_db2'
require 'stringio'
require 'test/unit'

class TestIbmDb2 < Test::Unit::TestCase

  def test_232
    assert_equal expected, capture {
      conn = DB2::connect(db,user,password)
      
      result = DB2::exec(conn, "select * from sales")
      
      for (i=0; i <= DB2::num_fields(result); i++)
       puts "#{DB2::field_name(result,i)}:#{DB2::field_type(result,DB2::field_name(result,i))}\n"
      end
      puts "-----\n"
      
      t = DB2::field_type(result,99)
      var_dump( t )
      
      t1 = DB2::field_type(result, "HELMUT")
      var_dump( t1 )
    }
  end

end

__END__
SALES_DATE:string
SALES_PERSON:string
REGION:string
SALES:int
:
-----
bool(false)
bool(false)