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 PRECISION
FLOAT [ ( 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.
  1. These are non-standard, Progress-defined SQL data types.
  2. A maximum of 15 digits to the right of the decimal point is allowed when running with the ANSI SQL (-Q) or ANSI SQL Client (-Q2) startup parameter.


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