OpenEdge Database - Products Enhancements - Progress Community

 OpenEdge Database

  • Virtualisation best practices

    I'm missing documentation, whitepapers and best practices around virtualisation. Like it or not but big parts of large systems are running in virtual environments and VMWare, OpenStack, NetApp, 3PAR, SAN-solutions etc is very common in everything...
  • 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 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...
  • 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...
  • Online schema changes

    Ok, it is possible to make some schema changes. Consider this scenario: A 24/7 business and I have to assure my business rules wasn't changed. If the database is running in multiple user mode, DDL operations like ALTER TABLE ADD PRIMARY KEY, DROP...
  • Stop Adminserver starting during install

    • Under Review
    • 0 Comments
    Ref the problems encountered in KB: 19590. Can we have an option to not start the Adminserver when installed OE. Thanks
  • 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...