SQL and Core Progress Data Types
When you execute a CREATE TABLE or ALTER TABLE statement in ESQL, you can specify supported SQL standard data types for the columns. However, Progress defines these columns using five core storage data types. Table B–1 lists the relationship between these types and their related storage capabilities.
Table B–1: SQL and Progress Core Data Types SQL
Data Type Progress
Data Type Storage
Capacity CHARACTER [ ( n ) ] CHARACTER Variable-length character strings, where n specifies the number of characters in the default display format, “x(n)”. Record size constrains the maximum length. DATE1 DATE Date values between 1/1/32768 B.C. and 12/31/32767 A.D. DECIMAL [ ( m [ ,n ] ) ]DOUBLE PRECISIONFLOAT [ ( m ) ]NUMERIC [ ( m [ ,n ] ) ]REAL DECIMAL Decimal numbers up to 50 digits long, with a maximum of 10 digits to the right of the decimal point,2 where m specifies the number of significant digits and n specifies the number of digits to the right of the decimal point. INTEGER INTEGER Whole numbers in the range -2,147,483,648 to 2,147,483,647. LOGICAL1 LOGICAL Boolean values such as YES/NO or TRUE/FALSE.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |