class TestIbmDb2 < Test::Unit::TestCase

  def test_194
    assert_expectf {
      assert_throws :'Fetch Failure' do
        conn = DB2::connect database, user, password
        sql = "SELECT empno, resume_format, resume
        FROM emp_resume
        WHERE resume_format = 'ascii'"
        if !conn
          throw 'no connection: ' + DB2::conn_errormsg()
        end
        result = DB2::exec conn, sql, {'cursor' => DB2::SCROLLABLE}
        i = 1
        while (row = DB2::fetch_array(result, i+=1))
         print_r(row)
        end
      end
    }
  end

end

__END__

