OpenEdge Database - Products Enhancements - Progress Community

 OpenEdge Database

  • Password Policy Management Implementation directly at Openedge Database Level

    • Under Review
    • 1 Comments
    In the context of different security audit point, the auditors are always pointing the following shortcoming : "when accessing directly the Openedge database, a password is required to authenticate the user but no password policy applies (for example...
  • Areas dedicated only for tables or indexes

    • Under Review
    • 0 Comments
    We have tables and indexes separated in different areas. But unfortunately it is possible to accidentally add a table to an index area or an index to a table area. It would be nice if there is for example an area property that tells OpenEdge that only...
  • Allow database logging to be turned off

    db.lg contains information that has been deemed sensitive. Would like the ability to turn this off so that no information is put into db.lg.
  • Allow changing the physical database name

    • Under Review
    • 0 Comments
    As of now the only support way I know to change the physical database name is via probkup / prorest. While this is a valid approach it consumes a lot of downtime on large database - up to some 20 hours on a 2 TB large database. Manually renaming all...
  • Allow character data type field to be initialized as GUID

    • Under Review
    • 0 Comments
    I know there are other discussions about adding a GUID data type or other such methods to accomplish this. However, several applications have already been using a GUID and storing it in a character field. This idea would allow for a character field...
  • Allow prostrct list when db path is wrong

    • Under Review
    • 0 Comments
    If you copy the DB to different path and you have no valid .st file there is no way to repair the db. The list command should always work and just export the .st files with the current paths (or maybe just with dots). The user can then correct them manually...
  • fix idxcheck utility to finish scanning the entire index in the event that there...

    sequence corruption breaks the idxcheck utility by causing it to either loop indefinitely if the recid sequence corruption is pointing backwards to a previously scanned recid, or will cause it to skip past recids completely if pointed forward towards...
  • OpenEdge should support Cancel request for long running SQL queries through JDBC...

    A normal user runs a SQL query with a tool like Squirrel and noticed that a function needs longer than expected. (a bad written function can result in a full table scan!) Pressing "Cancel" has no effect because OpenEdge still doesn't not...
  • Make TDE tenant configurable

    At this point, since all multi-tenant objects need to reside in Type II areas, it's is not possible to configure TDE per area / tenant. It's only possible to enable TDE per table / index / LOB which means that each of those would result in encryption...
  • Add indexes to _file and _index

    I often want to iterate over the application-specific records in _file or _index, e.g.: for each _file no-lock where _tbl-type = 't': // do stuff end. for each _index no-lock where not _index-name begins "_": // do other stuff end...