class TestIbmDb2 < Test::Unit::TestCase

  def test_034
    assert_expect {
      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 ""
      end
      
      
      DB2::close conn
    }
  end

end

__END__
   10  Sanders       20 Mgr         7        18357.50