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

class TestIbmDb2 < Test::Unit::TestCase

  def test_211
    assert_equal expected, capture {
      conn = DB2::connect(db,user,password)
      
      result = DB2::exec(conn, "select * from sales")
      
      i=1
      
      while (i <= DB2::num_fields(result))
       printf("%d size %d\n",i, DB2::field_display_size(result,i))
       i++
      end
      
      DB2::close(conn)
    }
  end

end

__END__
1 size 15
2 size 15
3 size 11
4 size 0