Progress
Embedded SQL-92
Guide and Reference


SMALLINT Data Type

The SMALLINT data type corresponds to an integer value of 2 bytes. The database representation, as well as the host language representation, is a signed short integer. The range of values corresponding to a column of this type is -32768 to +32767.

EXAMPLE

The following example shows how to declare and use a SMALLINT data type:

EXEC SQL BEGIN DECLARE SECTION ;
     short deptno_v ;
     char ename_v [19] ;
EXEC SQL END DECLARE SECTION ;
   .
   .
   .
EXEC SQL
     SELECT ename, deptno
     INTO :ename_v, :deptno_v
     FROM employee
     WHERE empno = 2828 ; 


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