Progress
DataServer
for ODBC Guide


Progress Database Objects and ODBC Data-source Objects

Progress 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 Progress database or ODBC data source’s logical structure. Table 2–1 lists Progress database objects and notes the ODBC data-source equivalents.

Table 2–1: Progress Database Objects and ODBC Data-source Objects
Progress
DB2
Informix
Microsoft Access
Sybase, Microsoft SQL Server 6.5
Table
Table
Table
Table
Table
Field
Column
Column
Column
Column
Record
Row
Row
Row
Row
Index
Index
Index
Index
Index
Unique index
Unique key
Primary key
Primary key
Primary key
Nonunique index
Nonunique key
Nonunique key
Nonunique key
Foreign key
Sequences
No equivalent
No equivalent
No equivalent
Native equivalent1
Validation expression
Check constraints
Data integrity
Validation expressions
Integrity constraint
Validation message
No equivalent
No equivalent
No equivalent
No equivalent
Initial value
Default
Default
No equivalent
Default
Schema trigger
Trigger
No equivalent
No equivalent
Trigger
No equivalent to stored procedures
Stored procedure
Stored procedure
No equivalent
Stored procedure
View
View
View
No equivalent
View
  1. The DataServer supports Progress sequences through native stored procedures and triggers.


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