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

class TestIbmDb2 < Test::Unit::TestCase

  def test_034
    assert_equal expected, capture {
      conn = DB2::connect(db,user,password)
      
      result = DB2::exec(conn, "select * from staff")
      
      if (row = DB2::fetch_assoc(result))
       printf("%5d  ",row['ID'])
       printf("%-10s ",row['NAME'])
       printf("%5d ",row['DEPT'])
       printf("%-7s ",row['JOB'])
       printf("%5d ", row['YEARS'])
       printf("%15s ", row['SALARY'])
       printf("%10s ", row['COMM'])
       puts "\n"
      end
      
      
      DB2::close(conn)
    }
  end

end

__END__
   10  Sanders       20 Mgr         7        18357.50