6. Embedded SQL for BASIC : Embedded SQL Statement Syntax for BASIC : Decimal Literals
 
Share this page                  
Decimal Literals
The preprocessor distinguishes between decimal and floating-point literals in SQL and Forms Runtime System (FRS) statements according to the following rules:
A literal containing a decimal point with no E notation is a decimal literal.
A literal with E notation is a floating-point literal.
For example:
exec sql insert
         into mytable (salary) values (23000.12)
exec sql insert
         into mytable (number) values (1.4E4)
In addition, the preprocessor treats integer literals greater than MAXINT as decimals. This allows host programs to input large integer values.
Ingres will treat "23000.00" as a decimal literal and "1.4E2" as a float literal.
However, applications will continue to use host language rules for interpreting literals appearing in host declarations. For example:
exec sql begin declare section
        integer2 i (1.234)
 exec sql end declare section
The literal '1.234' is interpreted according to the BASIC compiler rules.
This is consistent with the Ingres convention of interpreting SQL statements according to SQL rules and host statements according to host language compiler rules.