Progress
SQL-92
Guide and Reference
Supported Data Types and Corresponding SQL-92 Data Types
Progress SQL-92 supports many data types that do not correspond to Progress 4GL data types. Table C–1 lists the Progress data types that do correspond to Progress SQL-92 data types.
Table C–1: Progress 4GL Supported Data Types and Corresponding Progress SQL-92 Data Types Progress 4GL Data Type Progress SQL-92 Data Type ARRAY See the "Support for the ARRAY Data Type" section CHARACTER VARCHAR DATE DATE DECIMAL DECIMAL or NUMERIC INTEGER INTEGER LOGICAL BIT RAW VARBINARY RECID INTEGER
NOTES
- All other SQL-92 types are not compatible with 4GL. In particular, Progress SQL-92 CHARACTER data is not compatible with the 4GL. Use SQL-92 type VARCHAR to map 4GL CHARACTER data.
- Data columns created using the Progress SQL-92 environment that have a data type not supported in the Progress 4GL environment are not accessible through Progress 4GL applications and utilities.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |