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

class TestIbmDb2 < Test::Unit::TestCase

  def test_159a
    assert_equal expected, capture {
      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++
      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