class TestIbmDb2 < Test::Unit::TestCase

  def test_039
    assert_expectf {
      assert_throws :'Requested row number must be a positive value' do
        conn = DB2::connect db,user,password
        result = DB2::exec conn, "select * from animals", {'cursor' => DB2::SCROLLABLE}
        i = DB2::num_rows(result)-1
        while (row = DB2::fetch_row(result,i))
          result2 = DB2::exec conn, "select * from animals", {'cursor' => DB2::SCROLLABLE}
          j= DB2::num_rows(result2)-1
          puts ","
          while (row2 = DB2::fetch_row(result2,j))
            print "#{i})#{j} "
            j-=1
          end
          puts "#{i}, "
          i-=1
        end
      end
    }
  end

end

__END__
,
6)6 6)5 6)4 6)3 6)2 6)1 6)0