Release 10.1A: OpenEdge Getting Started:
New and Revised Features

> ## DataServers

> Release 10.1A includes the following enhancements in support of DataServer MS SQL Server ORACLE DataServers’ stored procedures functionality:

> - Use of the `LOAD-RESULT-INTO` function.

> Defined as part of the `RUN STORED-PROCEDURE` statement, the`LOAD-REULT-INTO` phrase enables an RDBMS stored procedure or send-sql-statement to be executed against a foreign data source for which the result sets that are derived can be loaded directly into one or more Progress static and/or dynamic temp-tables. The data in temp-tables can then be manipulated, employing all capabilities inherent to temp-tables.

> Depending on the type of temp-table you choose to populate using the `LOAD-RESULT-INTO` phrase, preliminary data setup tasks might be required. For example, result sets returned to a static or dynamic-prepared temp-table require you to define the layout of the result set data. In contrast, you do not have to perform any data setup tasks for a dynamic-unprepared temp-table; the temp-table’s schema is based on the result-set schema and a mapping of default Progress data types for each SQL type.

> As an enhancement to current stored procedure techniques, the use of the `LOAD-RESULT-INTO` phrase enables you to extend your code in new ways to more effectively employ more Progress 4GL features and functionality.

> - Support for`ROWID` functionality

> Made possible through the use of the optional`LOAD-RESULT-INTO` function in the `RUN STORED-PROCEDURE` statement, Release 10.1A supports a new adaptation of `ROWID` functionality, which in turn supports an alternative means to populate temp-tables of a ProDataSet Object.

> The purpose and default behavior of the `ROWID` function has not changed. That is, the `ROWID` continues to represent a unique key in a database even through it is not stored directly in the MS SQL data source. However, when used in the context of mapping a temp-table `ROWID` to a dataserver record identifier facilitated by the use of `LOAD-RESULT-INTO`, these values can be interpreted from one to the other (for example, from record id to `ROWID`.) The `ROWID` is stored along side its corresponding result rows within the temp-table.

> For detailed syntax updates to the `RUN STORED-PROCEDURE` statement, example usages of the `LOAD-RESULT-INTO` phrase and `ROWID` function, and more information about this functionality, see:

> Manuals: | OpenEdge Data Management: DataServer for ORACLE OpenEdge Data Management: DataServer for Microsoft SQL Server

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095