OpenEdge Database - Products Enhancements - Progress Community

 OpenEdge Database

  • Copy DB and schema

    No idea if this is something that others would want, but currently I need to copy a database and its schema and it would be a lot easier if I could do this with a simple procopy style command.
  • 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...
  • 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...
  • 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...
  • Message numbers for *all* messages

    Please add message numbers for ALL log messages.
  • 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
  • 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...