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
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |