OpenEdge Database - Products Enhancements - Progress Community

 OpenEdge Database

  • Identify Database by Abl / R-Code

    Nowadays there is no way to identify which database (Progress, Oracle or MSSQL) a program was compiled. Only internal procedures on Openedge can do it, when we got errors 869 e 916. Would be nice if exists a method on abl or r-code info to identify it...
  • Make the crash recovery system faster

    • Under Review
    Details: When a Progress database crashes, the database has to go through crash recovery before letting users back into the system. When this happens all incomplete transactions are backed out and the database is put back into a consistent state. The...
  • Add parameter name in OE Management

    When you bring up the config pages in OE Management you get a verbose name for the parameter you are setting but there is no indication what the actual parameter is that this refers to. It should be a lot clearer. How do I know which parameter I am actually...
  • Make trigger r-code reside in the database

    • Under Review
    Replication and Schema triggers r-code should be stored in the database. The CRUD operations cannot work without them. Currently if your PROPATH is not setup properly if an operation causes a trigger to fire, the code will not be found. If the r-code...
  • Automatically enable large files

    Enabling large files should be a standard behavior when creating a new database with f.e. prostrct create. Now you have to do this in a separate step, which is often forgotten.
  • Password Policy Management Implementation directly at Openedge Database Level

    • Under Review
    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...
  • Add rowversion functionality

    • Under Review
    Hi, Many of our customers do ETL on our databases. In order to optimize/minimize the number of records loaded and scanned, it would be handy to have a field in each table that gets updated on every change. We could add a timestamp field and modify it...
  • Back up and restore per area

    When doing f.e. maintenance on one area in a large database (view TB's), I need to back up the whole database. To backup only the area that I going to maintain saves time and disk space. Also in case of corruption in one area, I need to restore the...
  • System table descriptions

    Some of the more recently-added system tables have description values (_file._desc). Please add descriptions for all system tables and views.
  • Enhancement request: 'IN' operator for where clause

    OpenEdge currently doesn't have an 'IN' operator like SQL has. Example: SELECT * FROM customer WHERE state IN ('MA', 'NY', 'FL'). There are some ways to do this in OpenEdge: 1) FOR EACH customer WHERE LOOKUP(state...