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

class TestIbmDb2 < Test::Unit::TestCase

  def test_210
    assert_equal expected, capture {
      conn = DB2::connect(db,user,password)
      
      result = DB2::exec(conn, "select * from staff")
      cols = DB2::num_fields(result)
      
      for (i=0; i<cols; i++)
       size = DB2::field_display_size(result,i)
       puts "col:#{i} and size: #{size}\n"	
      end
      
      DB2::close(conn)
    }
  end

end

__END__
col:0 and size: 6
col:1 and size: 9
col:2 and size: 6
col:3 and size: 5
col:4 and size: 6
col:5 and size: 9
col:6 and size: 9