3. Statements : OpenROAD SQL Statements : Set Statement : Decimal
 
Share this page                  
Decimal
Set decimal specifies the character to be used as the decimal point in numeric literals. This option corresponds to the Ingres environment variable II_DECIMAL and is assigned the same values. Valid characters are the period (.) (as in 12.34) and the comma (,) (as in 12,34). The default is the period. See the Workbench User Guide for more information about setting this option.
To set the decimal character from within a 4GL routine, you must pass to the set decimal a variable containing the desired format with single quotes before and after the date format string. For example:
initialize()=
declare
          df = varchar(20) not null;
enddeclare
{
          df = '''’.''';
          set decimal :df;
}