Progress
DataServer
for ODBC Guide


User-defined Data Types

DB2, Sybase, and Microsoft SQL Server 6.5 data sources allow you to define your own data types that map to the data types for your data source. When the DataServer reads the schema information for a user-defined data type, it reads the data-source base data type and maps it to the equivalent Progress data type. Suppose, for example, that you create a data type named phone_number and map it to the char data type. In the schema holder, the DataServer represents your phone_number data type as a CHARACTER data type. If you make any changes to a user-defined data type, you must update the schema holder to reflect those changes.

Informix and Microsoft Access do not support user-defined data types.


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