Progress
Version 9
Product Update Bulletin
Preface
Purpose
This bulletin provides a brief description of the new andmodified features of Progress® Version 9.1, including Version 9.1E. It guides you to where you can find more detailed information on the changes in the documentation set.
Audience
This bulletin is written for Progress application developers and system administrators who are upgrading their license to Progress Version 9.1E from an earlier release of Progress.
Organization Of This Manual
"Overview Of New and Revised Features"
Summarizes the product features that are new or modified since Version 9.0B. Changes are listed by the Version 9.1 release during which they occurred. Entries include links to further information in the full documentation set.
Notes changes to the way Progress documentation is supplied. This chapter also provides a list of the books that were added, updated, or retired in the Progress documentation set for each Version 9.1 release.
Describes how changed features in Version 9.1 might affect application code and behavior created in previous versions of Progress.
Describes Version 9.1 enhancements to the Progress DataServers for Oracle®, Microsoft SQL, and ODBC.
"R-code Features and Functions"
Describes the structure and management of Progress r-code, the executable code into which Progress compiles 4GL procedures. It also describes techniques for tuning r-code size and performance, and the use of time stamps and cyclic redundancy checks (CRCs) to maintain r-code and database integrity.
Describes the architecture of the AppServer™ Internet Adapter (AIA) and how to use the AIA to develop and deploy distributed Progress applications that include AppServer or SonicMQ® Adapter components over the Web.
"Progress 4GL Language Reference"
Contains a list of the 4GL language elements that were added or modified in Progress Version 9.1D and 9.1E.
Describes enhancements to the Progress SQL Explorer tool
Describes enhancements to system initialization to allow use of Windows XP style, the Progress Explorer tool, and enhancements to AdminServer security.
Describes new WebClient™ installation procedures and Proxy authentication for WebClient.
Describe the new SQL-92 features for updated driver support, setting up the SQL-92 engine environment, case sensitivity in table columns, compatibility between SQL-92 and 4GL data handling, managing locked rows, multi-threading, Progress sequences, and the server locking feature.
Describes enhancements to the Database tools.
Describes how to invoke code dynamically.
"Optional NameServer Enhancement"
Describes the enhanced functionality that allows users to optionally specify no NameServer.
Describes the new and enhanced features of the installation and configuration processes for Windows and UNIX platforms.
"Progress Deployment Features"
Describes the deployment tasks required to enable specified Progress widgets to display using Windows XP style instead of Windows Classic style.
"Progress Startup Command and Parameter Reference"
Describes the new PROCLUSTER command that supports the new built-in Failover Clusters feature for the Progress RDBMS and describes several new startup parameters.
Describes the new support for reordering AI extents, extracting the active AI notes from a full AI extent, querying the status of AI extents, and handling AI extents for a target stand-by database that is copied or backed up by the operating system from a source database.
Describes the new built-in support for Failover Clusters in the Progress RDBMS.
"Accessing and Using PDF Documentation"
Describes how to use the Progress Software Corporation (PSC) PDF Electronic Documentation set for Version 9.1E.
Typographical Conventions
This manual uses the following typographical conventions:
The following typographical conventions are used to represent keystrokes:
- Small capitals are used for Progress key functions and generic keyboard keys.
END-ERROR, GET, GO
ALT, CTRL, SPACEBAR, TAB- When you have to press a combination of keys, they are joined by a hyphen. You press and hold down the first key, then press the second key.
CTRL-X
- When you have to press and release one key, then press another key, the key names are separated with a space.
ESCAPE H
ESCAPE CURSOR-LEFTSyntax Notation
The syntax for each component follows a set of conventions:
- Uppercase words are keywords. Although they are always shown in uppercase, you can use either uppercase or lowercase when using them in a procedure.
In this example, ACCUM is a keyword:
- Italics identify options or arguments that you must supply. These options can be defined as part of the syntax or in a separate syntax identified by the name in italics. In the ACCUM function above, the aggregate and expression options are defined with the syntax for the ACCUM function in the Progress Language Reference .
- You must end all statements (except for DO, FOR, FUNCTION, PROCEDURE, and REPEAT) with a period. DO, FOR, FUNCTION, PROCEDURE, and REPEAT statements can end with either a period or a colon, as in this example:
- Square brackets ([ ]) around an item indicate that the item, or a choice of one of the enclosed items, is optional.
In this example, STREAM stream, UNLESS-HIDDEN, and NO-ERROR are optional:
In some instances, square brackets are not a syntax notation, but part of the language.
For example, this syntax for the INITIAL option uses brackets to bound an initial value list for an array variable definition. In these cases, normal text brackets ( [ ] ) are used:
NOTE: The ellipsis (...) indicates repetition, as shown in a following description.
- Braces ({ }) around an item indicate that the item, or a choice of one of the enclosed items, is required.
In this example, you must specify the items BY and expression and can optionally specify the item DESCENDING, in that order:
In some cases, braces are not a syntax notation, but part of the language.
For example, a called external procedure must use braces when referencing arguments passed by a calling procedure. In these cases, normal text braces ( { } ) are used:
- A vertical bar (|) indicates a choice.
In this example, EACH, FIRST, and LAST are optional, but you can only choose one:
In this example, you must select one of logical-name or alias:
- Ellipses (...) indicate that you can choose one or more of the preceding items. If a group of items is enclosed in braces and followed by ellipses, you must choose one or more of those items. If a group of items is enclosed in brackets and followed by ellipses, you can optionally choose one or more of those items.
In this example, you must include two expressions, but you can optionally include more. Note that each subsequent expression must be preceded by a comma:
In this example, you must specify MESSAGE, then at least one of expression or SKIP, but any additional number of expression or SKIP is allowed:
In this example, you must specify {include-file, then optionally any number of argument or &argument-name = "argument-value", and then terminate with }:
- In some examples, the syntax is too long to place in one horizontal row. In such cases, optional items appear individually bracketed in multiple rows in order, left-to-right and top-to-bottom. This order generally applies, unless otherwise specified. Required items also appear on multiple rows in the required order, left-to-right and top-to-bottom. In cases where grouping and order might otherwise be ambiguous, braced (required) or bracketed (optional) groups clarify the groupings.
In this example, WITH is followed by several optional items:
In this example, ASSIGN requires one of two choices: either one or more of field, or one of record. Other options available with either field or record are grouped with braces and brackets. The open and close braces indicate the required order of options:
Syntax Notation — SQL-92
The syntax for each SQL-92 component follows a set of conventions:
- Uppercase words are keywords. Although they are always shown in uppercase, you can use either uppercase or lowercase when using them in an expression or a statement.
In this example, GRANT, RESOURCE, DBA, and TO are keywords:
- Italics identify options or arguments that you must supply. These options can be defined as part of the syntax or in a separate syntax identified by the name in italics. In the GRANT statement you must supply at least one user_name.
- Square brackets ([ ] ) around an item indicate that the item, or a choice of one of the enclosed items, is optional.
In this syntax example the first user_name is required, and additional user_name specifications are optional:
NOTE: The ellipsis (...) indicates repetition, as shown in a following description.
- Braces ({ }) around an item indicate that the item, or a choice of one of the enclosed items, is required.
In the GRANT example, you must specify either RESOURCE or DBA or both, and at least one user_name. Any user_name specifications after the first are optional:
In some cases, braces are not a syntax notation, but part of the language.
For example, this excerpt from an ODBC application invokes a stored procedure using the ODBC syntax { call procedure_name ( param ) }, where braces and parentheses are part of the language:
- A vertical bar (|) indicates a choice. In the CREATE SYNONYM example you must specify a table_name, view_name, or synonym but you can only choose one. Note that in all SQL-92 syntax, if you specify the optional owner_name qualifier, there must not be a blank between the period separator and the table_name or view_name or synonym:
In the DELETE FROM example, you must specify one of table_name or view_name:
- Ellipses (...) indicate that you can choose one or more of the preceding items. If a group of items is enclosed in braces and followed by ellipses, you must choose one or more of those items. If a group of items is enclosed in brackets and followed by ellipses, you can optionally choose one or more of those items.
In the ORDER BY example, you must include one expression (expr) or column position (posn), and you can optionally specify the sort order as ascending (ASC) or descending (DESC). You can specify additional expressions or column positions for sorting within a sorted result set. The SQL-92 engine orders the rows on the basis of the first expr or posn. If the values are the same, the second expr or posn is used in the ordering:
In the GRANT example, you must include one user_name, but you can optionally include more. Note that each subsequent user_name must be preceded by a comma:
- In many examples, the syntax is too long to place in one horizontal row. In such cases, optional items appear individually bracketed in multiple rows in order, left-to-right and top-to-bottom. This order generally applies, unless otherwise specified. Required items also appear on multiple rows in the required order, left-to-right and top-to-bottom. In cases where grouping and order might otherwise be ambiguous, braced (required) or bracketed (optional) groups clarify the groupings.
In this example, CREATE VIEW is followed by several optional items:
Progress Messages
Progress displays several types of messages to inform you of routine and unusual occurrences:
- Execution messages inform you of errors encountered while Progress is running a procedure (for example, if Progress cannot find a record with a specified index field value).
- Compile messages inform you of errors found while Progress is reading and analyzing a procedure prior to running it (for example, if a procedure references a table name that is not defined in the database).
- Startup messages inform you of unusual conditions detected while Progress is getting ready to execute (for example, if you entered an invalid startup parameter).
After displaying a message, Progress proceeds in one of several ways:
- Continues execution, subject to the error-processing actions that you specify, or that are assumed, as part of the procedure. This is the most common action taken following execution messages.
- Returns to the Progress Procedure Editor so that you can correct an error in a procedure. This is the usual action taken following compiler messages.
- Halts processing of a procedure and returns immediately to the Procedure Editor. This does not happen often.
- Terminates the current session.
Progress messages end with a message number in parentheses. In this example, the message number is 200:
On the Windows platform, use Progress online help to get more information about Progress messages. Many Progress tools include the following Help menu options to provide information about messages:
- Choose Help
Recent Messages to display detailed descriptions of the most recent Progress message and all other messages returned in the current session.
- Choose Help
Messages, then enter the message number to display a description of any Progress message. (If you encounter an error that terminates Progress, make a note of the message number before restarting.)
- In the Procedure Editor, press the HELP or F1 key.
On the UNIX platform, use the Progress PRO command to start a single-user mode character Progress client session and view a brief description of a message by providing its number. Follow these steps:
Other Useful Documentation
This section lists Progress Software Corporation documentation that you might find useful. Unless otherwise specified, these manuals support both Windows and Character platforms and are provided in electronic documentation format on CD-ROM.
Getting Started
Progress Installation and Configuration Guide Version 9 for UNIX
A manual that describes how to install and set up Progress Version 9.1 for the UNIX operating system.
Progress Installation and Configuration Guide Version 9 for Windows
A manual that describes how to install and set up Progress Version 9.1 for all supported Windows and Citrix MetaFrame operating systems.
Progress Application Development Environment — Getting Started (Windows only)
A practical guide to graphical application development within the Progress Application Development Environment (ADE). This guide includes an overview of the ADE and its tools, an overview of Progress SmartObject technology, and tutorials and exercises that help you better understand SmartObject technology and how to use the ADE to develop applications.
Progress Language Tutorial for Windows and Progress Language Tutorial for Character
Platform-specific tutorials designed for new Progress users. The tutorials use a step-by-step approach to explore the Progress application development environment using the 4GL.
Progress Master Glossary for Windows and Progress Master Glossary for Character (EDOC only)
Platform-specific master glossaries for the Progress documentation set. These books are in electronic format only.
Progress Master Index and Glossary for Windows and Progress Master Index and Glossary for Character (Hard copy only)
Platform-specific master indexes and glossaries for the Progress hard-copy documentation set.
Progress Startup Command and Parameter Reference
A reference manual that describes the Progress startup and shutdown commands that you use at the command line, and the startup parameters that you use for Progress processes. This guide also provides information about parameter usage and parameter files.
Welcome to Progress (Hard copy only)
A booklet that explains how Progress software and media are packaged. An icon-based map groups the documentation by functionality, providing an overall view of the documentation set. Welcome to Progress also provides descriptions of the various services Progress Software Corporation offers.
Development Tools
A guide to using the Application Development Model, Version 2 (ADM 2) application architecture to develop Progress applications. It includes instructions for building and using Progress SmartObjects.
A reference for the Application Development Model, Version 2 (ADM 2) application. It includes descriptions of ADM 2 functions and procedures.
Progress AppBuilder Developer’s Guide (Windows only)
A programmer’s guide to using the Progress AppBuilder visual layout editor. AppBuilder is a Rapid Application Development (RAD) tool that can significantly reduce the time and effort required to create Progress applications.
Progress Basic Database Tools (Character only; information for Windows is in online help)
A guide for the Progress Database Administration tools, such as the Data Dictionary.
Progress Basic Development Tools (Character only; information for Windows is in online help)
A guide for the Progress development toolset, including the Progress Procedure Editor and the Application Compiler.
A guide for the Progress Application Debugger. The Debugger helps you trace and correct programming errors by allowing you to monitor and modify procedure execution as it happens.
Progress Help Development Guide (Windows only)
A guide that describes how to develop and integrate an online help system for a Progress application.
Progress Translation Manager Guide (Windows only)
A guide that describes how to use the Progress Translation Manager tool to manage the entire process of translating the text phrases in Progress applications.
Progress Visual Translator Guide (Windows only)
A guide that describes how to use the Progress Visual Translator tool to translate text phrases from procedures into one or more spoken languages.
Reporting Tools
Progress Report Builder Deployment Guide (Windows only)
An administration and development guide for generating Report Builder reports using the Progress Report Engine.
Progress Report Builder Tutorial (Windows only)
A tutorial that provides step-by-step instructions for creating eight sample Report Builder reports.
Progress Report Builder User’s Guide (Windows only)
A guide for generating reports with the Progress Report Builder.
Progress Results Administration and Development Guide (Windows only)
A guide for system administrators that describes how to set up and maintain the Results product in a graphical environment. This guide also describes how to program, customize, and package Results with your own products. In addition, it describes how to convert character-based Results applications to graphical Results applications.
Progress Results User’s Guide for Windows and Progress Results User’s Guide for UNIX
Platform-specific guides for users with little or no programming experience that explain how to query, report, and update information with Progress Results®. Each guide also helps advanced users and application developers customize and integrate Results into their own applications.
4GL
Building Distributed Applications Using the Progress AppServer
A guide that provides comprehensive information about building and implementing distributed applications using the Progress AppServer. Topics include basic product information and terminology, design options and issues, setup and maintenance considerations, 4GL programming details, and remote debugging.
Progress External Program Interfaces
A guide to the external programming interfaces supported by Progress. This manual covers the Host Language Call (HLC) Interface, the system clipboard, named pipes, shared libraries and DLLS, Windows Dynamic Data Exchange (DDE), COM objects, ActiveX Automation, ActiveX controls, sockets, XML, SAX, and the SonicMQ 4GL Adapter.
Progress Internationalization Guide
A guide to developing Progress applications for markets worldwide. The guide covers both internationalization—writing an application so that it adapts readily to different locales (languages, cultures, or regions)—and localization—adapting an application to different locales.
A three-volume reference set that contains extensive descriptions and examples for each statement, phrase, function, operator, widget, attribute, method, and event in the Progress language.
A manual that describes how to use the new WebClient, AppServer Internet Adapter, SmartObjects™, and SonicMQ Adapter to create applications tailored for Internet, intranet, and extranet environments.
A two-volume handbook that details advanced Progress programming techniques.
Database
Progress Database Design Guide
A guide that uses a sample database and the Progress Data Dictionary to illustrate the fundamental principles of relational database design. Topics include relationships, normalization, indexing, and database triggers.
Progress Database Administration Guide and Reference
This guide describes Progress database administration concepts and procedures. The procedures allow you to create and maintain your Progress databases and manage their performance.
DataServers
Progress DataServer Guides
These guides describe how to use the DataServers to access non-Progress databases. They provide instructions for building the DataServer modules, a discussion of programming considerations, and a tutorial.
Each DataServer has its own guide as follows:
MERANT ODBC Branded Driver Reference
The Enterprise DataServer for ODBC includes MERANT ODBC drivers for all the supported data sources. For configuration information, see the MERANT documentation, which is available as a PDF file in installation-path
\odbc
. To read this file you must have the Adobe Acrobat Reader Version installed on your system. If you do not have the Adobe Acrobat Reader, you can download it from the Adobe Web site at:http://www.adobe.com/products/acrobat/readstep.html.
SQL-89/Open Access
Progress Embedded SQL-89 Guide and Reference
A guide to Progress Embedded SQL-89 for C, including step-by-step instructions on building ESQL-89 applications and reference information on all Embedded SQL-89 Preprocessor statements and supporting function calls. This guide also describes the relationship between ESQL-89 and the ANSI standards upon which it is based.
Progress Open Client Developer’s Guide
A guide that describes how to write, build, and deploy Java™ and ActiveX applications, and Java applets that run as clients of the Progress AppServer. This guide includes information about how to expose the AppServer as a set of Java classes or as an ActiveX server, and how to choose an Open Client distribution package fro run time.
Progress SQL-89 Guide and Reference
A user guide and reference for programmers who use interactive Progress/SQL-89. It includes information on all supported SQL-89 statements, SQL-89 Data Manipulation Language components, SQL-89 Data Definition Language components, and supported Progress functions.
SQL-92
Progress Embedded SQL-92 Guide and Reference
A guide to Progress Embedded SQL-92 for C, including step-by-step instructions for building ESQL-92 applications and reference information about all Embedded SQL-92 Preprocessor statements and supporting function calls. This guide also describes the relationship between ESQL-92 and the ANSI standards upon which it is based.
A guide to the Java Database Connectivity (JDBC) interface and the Progress SQL-92 JDBC driver. It describes how to set up and use the driver and details the driver’s support for the JDBC interface.
A guide to the ODBC interface and the Progress SQL-92 ODBC driver. It describes how to set up and use the driver and details the driver’s support for the ODBC interface.
Progress SQL-92 Guide and Reference
A user guide and reference for programmers who use Progress SQL-92. It includes information on all supported SQL-92 statements, SQL-92 Data Manipulation Language components, SQL-92 Data Definition Language components, and Progress functions. The guide describes how to use the Progress SQL-92 Java classes and how to create and use Java stored procedures and triggers.
Deployment
Progress Client Deployment Guide
A guide that describes the client deployment process and application administration concepts and procedures.
A guide to using the Developer’s Toolkit. This guide describes the advantages and disadvantages of different strategies for deploying Progress applications and explains how you can use the Toolkit to deploy applications with your selected strategy.
A guide that explains how to use the Progress toolset to build applications that are portable across all supported operating systems, user interfaces, and databases, following the Progress programming model.
WebSpeed
Provides an introduction to the WebSpeed® Workshop tools for creating Web applications. It introduces you to all the components of the WebSpeed Workshop and takes you through the process of creating your own Intranet application.
WebSpeed Installation and Configuration Guide
Provides instructions for installing WebSpeed on Windows and UNIX systems. It also discusses designing WebSpeed environments, configuring WebSpeed Brokers, WebSpeed Agents, and the NameServer, and connecting to a variety of data sources.
Provides a complete overview of WebSpeed and the guidance necessary to develop and deploy WebSpeed applications on the Web.
WebSpeed Product Update Bulletin
A booklet that provides a brief description of each new feature of the release. The booklet also explains where to find more detailed information in the documentation set about each new feature.
Welcome to WebSpeed (Hard copy only)
A booklet that explains how WebSpeed software and media are packaged. Welcome to WebSpeed! also provides descriptions of the various services Progress Software Corporation offers.
Reference
Pocket Progress and WebSpeed (Hard copy only)
A reference that lets you quickly look up information about the Progress and SpeedScript® languages and about the Progress and WebSpeed programming environments.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |