class TestIbmDb2 < Test::Unit::TestCase

  def test_066
    assert_expectf {
      conn = DB2::connect database, user, password
      result = DB2::tables conn, NULL, user.upcase, 'ANIM%'
      while (row = DB2::fetch_object(result))
        puts "Schema:  #{row.TABLE_SCHEM}"
        puts "Name:    #{row.TABLE_NAME}"
        puts "Type:    #{row.TABLE_TYPE}"
        print "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: