OpenEdge Database - Products Enhancements - Progress Community

 OpenEdge Database

  • add remote host capability to proadsv

    We have multiple admin server installs across many unix servers. At times the admin server (11.3.2) will hang. Others services like OEM and app servers can still be active. When this happens we will not get alerts from that server. We need to know when...
  • Allow DataServer tool to generate SQL statement to change field width.

    • Under Review
    • 0 Comments
    I would like to just change the WIDTH for a field. I ran "Generate Delta.sql OpenEdge to ORACLE...". It does not generate SQL command to alter field width. To duplicate it, add the following lines to a Progress delta.df file (Note: repace {field...
  • 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...
  • A new costing algorithm in the SQL optimizer, to eliminate performance issues noted...

    • Under Review
    • 0 Comments
    Several months ago a customer I support was having varying results using the SQL Optimizer tool. We opened a support ticket with Progress support and they indicated this was not an issue with the tool per se, but a problem how SQL coordinates among join...
  • Make large file support available without ENTERPRISE.

    In this day and age with databases frequently being very large (compared to 10 years ago) it seems counter-intuitive to require Enterprise RDBMS in order to serve up Large File enable databases. I want to serve up a copy of our production database against...
  • Make VST date+time fields DATETIME instead of CHARACTER

    The subject explains it all: VST tables are filled with dates and times, for instance _Connect._Connect-Time these fields are always (except possibly _KeyEvt._KeyEvt-Date) character fields. Make them datetime(-tz) instead, or add corresponding datetime...
  • bprowsdlproc script

    Opposed to bprowsdldoc this script produces a procedure with internal procedures per operation as documented in the html pages. This procedure can then be added to an application and be edited with application logic.
  • BUFFER-WRITE-XML method to write a single record to xml

    We're lacking the ability to write a single record of a (temp-)table to xml. In order to do this we dynamically create a temp-table with a single record in order to write it to xml. As WRITE-XML is currently the same for buffer handle and table handle...
  • prostrct create possibility to use kilobyte value for -blocksize

    Currently when creating a new database one has to type prostrct create database .. -blocksize X , where X is the desired block size in bytes. Should one happen to make a typo, say 8191 instead of 8192, one might get a database with 4kb block size. ...
  • 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...