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:
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
InitialProgramming 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.