class TestIbmDb2 < Test::Unit::TestCase

  def test_261
    assert_expect do
      conn = DB2::connect database, user, password
      
      sql = "SELECT breed, RTRIM(name) AS name
        FROM animals
        WHERE id = ?"
      
      if conn
        stmt = DB2::prepare conn, sql
        DB2::execute stmt, [0]
        
        while (pet = DB2::fetch_object(stmt))
          print "Come here, #{pet.NAME}, my little #{pet.BREED}!"
        end
        DB2::close conn
        
      else
        puts "Connection failed."
      end
    end
  end

end

__END__
Come here, Pook, my little cat!