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

class TestIbmDb2 < Test::Unit::TestCase

  def test_066
    assert_equal expected, capture {
      conn = DB2::connect(database, user, password)
      
      result = DB2::tables(conn, NULL, strtoupper(user), 'ANIM%')
      
      while (row = DB2::fetch_object(result))
        puts'Schema:  ' . row->TABLE_SCHEM . "\n"
        puts'Name:    ' . row->TABLE_NAME . "\n"
        puts'Type:    ' . row->TABLE_TYPE . "\n"
        puts'Remarks: ' . row->REMARKS . "\n\n"
      end
      
      DB2::free_result(result)
      DB2::close(conn)
    }
  end

end

__END__
Schema:  %s
Name:    ANIMALS
Type:    TABLE
Remarks: 

Schema:  %s
Name:    ANIME_CAT
Type:    VIEW
Remarks: