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

class TestIbmDb2 < Test::Unit::TestCase

  def test_261
    assert_equal expected, capture {
      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))
          puts"Come here, {#{pet}->NAME}, my little {#{pet}->BREED}!"
        end
        DB2::close(conn)
        
      else
        puts"Connection failed.\n"
      end
    }
  end

end

__END__
Come here, Pook, my little cat!