OpenEdge Database - Products Enhancements - Progress Community

 OpenEdge Database

  • Log should create after successful .df file load

    Hi All, I am just working with one customer and really like the idea towards enhancing the log captured mechanism during DF logs. We only have .e files created when there is error in DF load. Customer wants to see log messages as well when after every...
  • ODBC/SQL: Allow dynamic, transactionally-safe sequence updates

    Sequences should be able to be updated to dynamic values in a transactionally-atomic manner (e.g. setting the current value to MIN(a, b)). Possible use-cases include using a self-join to find the first unused id and setting the index for other clients...
  • Enable Conversion of DateTime fields to DateTime-TZ fields Within Dictionary Mai...

    • Under Review
    • 0 Comments
    I notice that for some time it has been possible to convert INTEGER field type to INT64 within dictionary maintenance. Would it be possible to add datetime to datetime-tz as well. As our product is reaching larger markets we are beginning to see situations...
  • Support "SELECT .. ORDER BY .. FOR UPDATE"

    • Under Review
    • 0 Comments
    When I use "SELECT .. ORDER BY .. FOR UPDATE" in sql, I get some errors. From the below syntax, I would expect it is supported. SELECT [ ALL | DISTINCT ] [ TOP n ] { * | { table_name | alias} * [ , { table_name| alias} * ] ... | expr [ ...
  • Add exceptions (exclusion filters) to database-request statement caching

    Background With database-request statement caching you can see, what a specific client is doing (= the stack trace of the last database-request statement) : http://knowledgebase.progress.com/articles/Article/P150383 This can be handy, for instance...
  • New Database Server parameter, preventing the selection of unspecified values (?...

    • Under Review
    • 2 Comments
    Quote from the documentation: http://documentation.progress.com/output/OpenEdge114/pdfs/webpapers/ABL_triggers_and_indexes.pdf (site 24) "Indexes and unknown values. If an index contains an Unknown value (?), the AVM sorts that value higher than...
  • Probkup option to output analysis file

    This has been suggested in the past; I think I heard it from Mike Furgal. The request is to add syntax to probkup to optionally have it output an analysis file (db/tab/idx/ch).
  • Better support for concatenated queries

    • Under Review
    • 0 Comments
    Per https://progress.my.salesforce.com/kA0a0000000ddpD I think there should be a cleaner way to use SQL to query data and achieve the same results. OR create a new structure (Stored Procedure) that can be executed from the SQL statement to accomplish...
  • Extend OEM alert watches beyond scheduled period

    • Under Review
    • 0 Comments
    In our OEM standard installation, I have several schedules applied to a database over the course of a day - regular hours, backup period and 2 overnight periods (because schedules cannot cross midnight). An alert on busy DB activities was thrown at the...
  • Provide more information in database lg file when Corporate scanning tool connects...

    • Under Review
    • 0 Comments
    Clarifying Information Qualys Corporate Vulnerability Scan is being run against the database. Port scanner is scanning the database listener port. Clients are not being disconnected. Database is not being abnormally shut down. Error in log...