class TestIbmDb2 < Test::Unit::TestCase

  def test_159a
    assert_expect {
      conn = DB2::connect db,user,password
      result = DB2::exec conn, "select prstdate,prendate from project"
      i=1
      while (row = DB2::fetch_assoc(result))
        printf("%3d %10s %10s\n",i, row['PRSTDATE'], row['PRENDATE'])
        i+=1
      end
    }
  end

end

__END__
  1 1982-01-01 1983-02-01
  2 1982-01-01 1983-02-01
  3 1982-01-01 1983-02-01
  4 1982-01-01 1983-02-01
  5 1982-01-01 1983-02-01
  6 1982-01-01 1983-02-01
  7 1982-01-01 1983-02-01
  8 1982-01-01 1983-02-01
  9 1982-01-01 1983-02-01
 10 1982-01-01 1982-12-01
 11 1982-01-01 1982-12-01
 12 1982-02-15 1982-12-01
 13 1982-01-01 1983-02-01
 14 1982-01-01 1983-02-01
 15 1982-01-01 1983-02-01
 16 1982-01-01 1983-02-01
 17 1982-01-01 1983-02-01
 18 1982-01-01 1983-02-01
 19 1982-01-01 1983-02-01
 20 1982-01-01 1982-09-15