class TestIbmDb2 < Test::Unit::TestCase

  def test_213
    assert_expect {
      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) || 0)
      i = "REGION"
      printf("%s size %d\n",i, DB2::field_display_size(result,i) || 0)
      i = "REgion"
      printf("%s size %d\n",i, DB2::field_display_size(result,i) || 0)
      i = "HELMUT"
      printf("%s size %d\n",i, DB2::field_display_size(result,i) || 0)
      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)