4. Embedded SQL for Fortran : Fortran Variables and Data Types : Data Type Conversion : Runtime Numeric Type Conversion
 
Share this page                  
Runtime Numeric Type Conversion
The Ingres runtime system provides automatic data type conversion between numeric-type values in the database and the forms system and numeric Fortran variables. The standard type conversion rules in UNIX are followed according to standard Fortran rules. In VMS, the standard VAX rules are followed. For example, if you assign a real variable to an integer-valued field, the digits after the decimal point of the variable's value are truncated. Runtime errors are generated for overflow on conversion.
The default size of integers in Embedded SQL/Fortran is four bytes. You can change the default size to two bytes by means of the -i2 preprocessor flag. If you use this flag, you should also compile the program with the -i2 compiler flag (UNIX), the noi4 qualifier (VMS), or the /integer_size:16 or /4I2 (Windows).
The Ingres money type is represented as real*8, an 8-byte real value.