skip to main content
OpenEdge Data Management: DataServer for ODBC
Programming Considerations : Database design issues : OpenEdge database objects and ODBC data-source objects
 

OpenEdge database objects and ODBC data-source objects

OpenEdge databases and the ODBC data sources share the structural elements common to relational databases, but each system has its own elements. These elements, called database or data-source objects, are components of the OpenEdge database or ODBC data source's logical structure. The following table lists OpenEdge database objects and notes the ODBC data-source equivalents.
Table 4. OpenEdge database and ODBC data-source objects
OpenEdge
DB2 UDB
Sybase
File
Table
Table
Field
Column
Column
Record
Row
Row
Index
Index
Index
Unique index
Unique key
Primary key
Nonunique index
Nonunique key
Foreign key
Sequences1
No equivalent
Native equivalent2
Validation expression
Check constraints
Integrity constraint
Validation message
No equivalent
No equivalent
Initial value
Default
Default
Schema trigger
Trigger
Trigger
No equivalent to stored procedures
Stored procedure
Stored procedure
View
View
View
1 Sequences in DB2 UDB become native objects depending upon the DB2 UDB version and platform. For instance, sequences only become native database objects in DB2/400 starting with iSeries OS version 5.3.

2 The DataServer supports Progress ABL sequences through native stored procedures and triggers.