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

class TestIbmDb2 < Test::Unit::TestCase

  def test_213
    assert_equal expected, capture {
      conn = DB2::connect(db,user,password)
      
      result = DB2::exec(conn, "select * from sales")
      
      i = "sales_person"
      
      printf("%s size %d\n",i, DB2::field_display_size(result,i))
      
      i = "REGION"
      
      printf("%s size %d\n",i, DB2::field_display_size(result,i))
      
      i = "REgion"
      
      printf("%s size %d\n",i, DB2::field_display_size(result,i))
      
      i = "HELMUT"
      
      printf("%s size %d\n",i, DB2::field_display_size(result,i))
      
      t = DB2::field_display_size(result,"")
      
      var_dump( t )
      
      t = DB2::field_display_size(result,"HELMUT")
      
      var_dump( t )
      
      t = DB2::field_display_size(result,"Region")
      
      var_dump( t )
      
      t = DB2::field_display_size(result,"SALES_DATE")
      
      var_dump( t )
    }
  end

end

__END__
sales_person size 0
REGION size 15
REgion size 0
HELMUT size 0
bool(false)
bool(false)
bool(false)
int(10)