Progress
Embedded SQL-92
Guide and Reference


Implicit Data Conversion

Progress SQL-92 performs the required data conversions between data types wherever possible. For example, when delivering each SELECT list value to the host variables in an INTO clause, Progress SQL-92 implicitly converts the data value, if necessary, from the database representation to the host language representation.

If the database column is of type SMALLINT, Progress SQL-92 retrieves the value of that column in to a host variable of type long, and automatically converts the value from SMALLINT to long integer type. Presently, implicit type conversions between all data types are not supported. For example, if you use an INTEGER host variable to hold a CHARACTER value, there is no implicit data conversion. If you do not explicitly convert the INTEGER variable to CHAR and you attempt to access it as CHAR, an error is returned.


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