OpenEdge Database - Products Enhancements - Progress Community

 OpenEdge Database

  • Allow field extent change with drop/add field

    • Under Review
    • 2 Comments
    Allow changing the extent of a database field without dropping the field. Preferably on-line, through fast off-line schema change if on-line not possible
  • know where all the databases are on Windows

    • Under Review
    • 2 Comments
    On UNIX/Linux there is the "proutil -C dbipcs" command to show where all the running databases are on the OS. On WIndows there is no such command. Ideally, a command that uses conmgr.properties and then determines which one is running would...
  • Avoid large log files

    Database log files often grow very large. Analysis inside a text or log-file editor is not so handy. I suggest you to manage database log files in a more conveniently way. A very basic enhancement would be the definition of a threshold size (just like...
  • Real database backup file compression

    We now are using 3th party software to compress the database backup file. First we have to wait until the backup is completed. The backup file is already using disk space. After completion we start the compression. Which also takes time and disk space...
  • Support for RIGHT OUTER-JOIN

    Hi, RIGHT OUTER-JOIN is currently not a part of the ABL syntax. The knowledge base states: "In the 4GL, you can also implement a RIGHT-OUTER-JOIN by using a LEFT-OUTER-JOIN with the tables in reverse order..." This will however result...
  • Allow more data-type changes

    • Under Review
    • 0 Comments
    It is currently possible to change the data-type of a field from int to int64 without dropping the field. Please add support for date -> datetime / datetime-tz int / int64 -> decimal anything -> character see also PugChallenge database...
  • Support adding database triggers (schema change) on-line

    • Under Review
    • 0 Comments
    Customers demand very very high up-time and one thing we still cannot do is add a database table trigger on-line. We can add new tables and fields on-line which is excellent. We can also add Indexes on-line (not that easy but at least it can be done)...
  • Multi-segment word index

    • Under Review
    • 0 Comments
    Word indexes can not contain multiple fields. Change this to word indexing only allowed on the last segment (similar to abbrev). Use case, example on sports ; New table : ItemTranslation, translation table for item : Fields Itemnum LanguageCode...
  • Allow local administrators group (including domain administrators) to run jobs against...

    • Under Review
    • 0 Comments
    Currently, on a Windows server, only a local server administrator can shut down, or run command-line jobs (proshut, etc.) against, a database if the database was started by the local administrator. One problem with that approach is that local administrator...
  • Option for probkup to remove target file before backing up

    On Windows, if the target backup file already exists, the backup can take a lot longer to complete. This is known, so we have to script for this by deleting the target file before backing up. It would be nice to remove this step with an optional parameter...