class TestIbmDb2 < Test::Unit::TestCase

  def test_213
    assert_expect do
      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

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