Progress
Version 9
Product Update Bulletin
Changes In Version 9.1E
This section lists new and enhanced features in Version 9.1E. For more detailed information about a feature, you are referred to the appropriate appendix in this bulletin or other Progress documentation.
- Administration — Version 9.1E includes the following enhancements and changes to administration:
- New Progress initialization file option,
UseClipChildren
, which lets you display the following Progress widgets in Windows XP style instead of using Windows classic style: BUTTON (with a standard label, that cannot accept focus, and does not have an image), COMBO-BOX, DIALOG-BOX, EDITOR, FILL-IN, RADIO-SET, SELECTION-LIST, SLIDER, TOGGLE-BOX, and WINDOW.For more information, see:
Manual: "Administration" in this bulletin.- Database — Version 9.1E includes the following new and enhanced features to the database:
- Support for Failover Clusters, formerly the Fathom™ Clusters product, is integrated into the Progress Enterprise RDBMS™ product. This includes the addition of the Failover Clusters command (
procluster
), an a enterprise database startup command to start an automated fail over process for a Progress database and its related resources. For complete syntax and more information see:
Manual: "Failover Clusters" in this bulletin.- The addition of the PROSTRCT qualifier REORDER AI to allow the reordering of AI extents to ensure that all empty extents are moved in front of all FULL or LOCKED extents, enabling the database to continue to switch AI extents. For complete syntax and more information see:
Manual: "Progress RDBMS" in this bulletin.- The addition of the RFUTIL qualifier AIMAGE EXTRACT to provide the ability to extract the active AI notes from a full after-image extent. For complete syntax and more information see:
Manual: "Progress RDBMS" in this bulletin.- The addition of the RFUTIL qualifier AIMAGE QUERY to enable the user to query and obtain information about the status of AI extents. For complete syntax and more information see:
Manual: "Progress RDBMS" in this bulletin.- The addition of the RFUTIL qualifier SEQUENCE to update the sequence number of a hot stand-by target database to expect the last AI extent in use at the time of the operating system copy or backup of the source database. For complete syntax and more information see:
Manual: "Progress RDBMS" in this bulletin.- DataServers — Version 9.1E includes the following enhancements to provide additional support for improving the performance of Progress Personal DataServer for Microsoft SQL Server™ applications:
- The DataServer for MS SQL Server is enhanced with the ability to form a connection pool. A connection pool is a set of database connections that are available for an application to use without having to be reestablished. Connection pooling significantly improves the cursor management associated with multi-table joins.
- “FireHose Cursors” deliver a streamlined, unmanaged, cursor-processing mechanism that handles result sets from a DataServer query. The FireHose cursors FAST-FORWARD Only record sets will be the default mechanism for handling read-only results.
For more information about these enhancements, see:
Manual: "Progress DataServer" in this bulletin.- Deployment — Version 9.1E incorporates the following new deployment feature:
- Windows XP-style widget support lets you display the following Progress widgets in Windows XP style instead of using Windows Classic style: BUTTON (with a standard label, that cannot accept focus, and does not have an image), COMBO-BOX, DIALOG-BOX, EDITOR, FILL-IN, RADIO-SET, SELECTION-LIST, SLIDER, TOGGLE-BOX, and WINDOW.
For more information, see:
Manual: "Progress Deployment Features" in this bulletin.- Electronic Documentation — For Progress Version 9.1E, the DynaText and DynaWeb electronic documentation formats are replaced by PDF and browser-based electronic documentation formats.
For more information on these new electronic documentation formats, see:
Manual: "Features By Book," and "Accessing and Using PDF Documentation," in this bulletin.- Progress 4GL Reference — Version 9.1E incorporates new and modified 4GL language elements:
- New SESSION System Handle attribute: STARTUP-PARAMETERS attribute
- Modified SHOW-STATS statement: Modified to write the value of the STARTUP-PARAMETERS attribute to the
client.mon
output file.For more information, see:
Manual: "Progress 4GL Language Reference" in this bulletin. HTML Online Help: Progress 4GL Language Reference Help- SQL-92 — Version 9.1E includes the following enhancements and changes to SQL-92:
- JDBC and ODBC drivers have been certified with Version 9.1E SQL-92.
- Version 9.1E provides you with scripts you can use to define environment settings for the SQL-92 engine.
- The
CREATE
TABLE
statement now provides you with the ability to define case sensitivity in a character column.- The -checkwidth startup parameter enables the 4GL client to compare data of a Progress 4GL table against the SQL metaschema
_width
field value before updating a database record.- The DBTool utility identifies and fixes SQL width violations of character and decimal data, as well as identifies data values incompatible with SQL-92.
- The
PROSQL_LOCKWAIT_TIMEOUT
environment variable enables you to determine how long SQL clients can wait in a lock queue for a particular row.- The
READPAST
locking hint skips locked rows during the execution of aSELECT
statement. This option enables a transaction to skip locked rows rather than block the transaction.For more information on SQL-92, see:
Manual: "SQL-92" in this bulletin.- Startup Commands and Parameters — Version 9.1E incorporates the following new and modified startup commands and parameters:
- New PROCLUSTER command, which starts an automated failover process for a Progress database and its related resources.
- New AdminServer Group (-admingroup) startup parameter, which lets you authorize Progress AdminServer access and operational privileges for one or more user groups.
- New Check Width (-checkwidth) startup parameter, which lets you specify whether Progress compares CHARACTER, DECIMAL, and RAW field data against the metaschema _width field value before updating a database record.
- New Network Message Compression (-mc) startup parameter, which lets you compress messages between a Progress client and the Progress AppServer™.
- New Temporary Table Database Block Size (-tmpbsize) startup parameter, which lets you specify the temporary table database block size.
- Updated Number of Buffers for Temporary Tables (-Bt) startup parameter, which was formerly named Buffer Size for Temporary Tables and lets you specify the number of buffers in the temporary table database buffer pool.
- Updated Maximum Dynamic Server (-maxport) startup parameter, which lets you specify the highest port number in a specified range of port numbers accessible to a client, and now has a multi-user default value of 2000.
For more information, see:
Manual: "Progress Startup Command and Parameter Reference" in this bulletin. HTML Online Help: Progress Startup Command and Parameter Reference Help
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |