Progress
Embedded SQL-92
Guide and Reference


INTEGER Data Type

The INTEGER data type corresponds to an integer of 4 bytes. The database representation, as well as host language representation, is a long integer. You must express integer constants in decimal notation without embedded commas and without a decimal point.

The integer data can be preceded with an optional plus or minus sign. The range of values for a column of this type is -2147483648 to +2147483647.

EXAMPLE

The following example shows how to use the INTEGER data type expressed as a host language long integer:

EXEC SQL BEGIN DECLARE SECTION ;
     long qty_v ;
EXEC SQL END DECLARE SECTION ;
 
EXEC SQL
     SELECT qty
     INTO :qty_v
     FROM orders
     WHERE order_no = 1002 ; 


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