Try OpenEdge Now
skip to main content
DataServer for Oracle
Introduction : Guidelines for using the DataServer
 

Guidelines for using the DataServer

OpenEdge supports many capabilities not found in other database management systems, such as backward scrolling and the ability to find the previous or last record in a table. The DataServer supports these and other programming and database features to ensure that your applications work with both OpenEdge and Oracle databases.
The DataServer allows you to use OpenEdge features as extensions to Oracle. Some of the OpenEdge programming and database design techniques that you can implement on your Oracle database using the DataServer are:
*ROWID function
*Arrays
*Cursor repositioning
*Case-insensitive indexes
For access to some of these features, you might have to make minor modifications to your Oracle tables. For a discussion of these issues and instructions for modifying Oracle tables, see Initial Programming Considerations
When you create an Oracle database from an existing OpenEdge database with the OpenEdge DB-to-Oracle migration utility and you select the Create RECID option, you can use the FIND PREV/LAST statements, which takes advantage of ABL-like cursor behavior.
How you use the DataServer depends on whether you plan to access information in an Oracle database through an OpenEdge or WebSpeed application, or whether you plan to migrate an OpenEdge database to Oracle. The following sections outline these possibilities and point you to the information you need in this manual.
Note: If you are developing a WebSpeed application, all the programming information in this guide applies to your SpeedScript code. For information on connecting WebSpeed Agents, see OpenEdge Getting Started: WebSpeed Essentials.
* Using the OpenEdge DataServer for Oracle for the first time
* Using the DataServer to migrate a database from OpenEdge to Oracle
* Upgrading to the OpenEdge Release 10 DataServer for Oracle