Specifies the decimal separator setting used by the back-end DBMS that you are accessing in InfoMaker. If your DBMS uses a decimal separator other than period (.), which is the default, set DecimalSeparator to the value for your DBMS to ensure that InfoMaker correctly handles numeric strings returned from your database.
DIR Sybase DirectConnect
ODBC (if driver and back-end DBMS support this feature)
OLE DB
O90 Oracle9i
O10 Oracle 10g
ORA Oracle 11g
SNC SQL Native Client for Microsoft SQL Server
DecimalSeparator='value'
DecimalSeparator='.'
When to set DecimalSeparator The DecimalSeparator parameter currently supports period (.)
and comma (,) as valid values. Therefore, if the decimal separator
setting for your DBMS is a comma, you should set the DecimalSeparator
parameter to ',' (comma)
to make sure InfoMaker correctly handles numeric strings returned
from your database.
Example using Oracle Assume you are accessing an Oracle database in InfoMaker and the decimal separator setting is a comma (,). Oracle returns to InfoMaker the numeric string '123,50' containing a comma instead of a period as the decimal separator. InfoMaker then sends this string to its decimal conversion routines.
By default, the InfoMaker decimal conversion routines expect
a period as the decimal separator. If you set the DecimalSeparator
parameter to ',' (comma), InfoMaker correctly
handles this string and returns it as '123,50'.
To specify that your DBMS uses a comma (,) as the decimal separator setting, type a comma (,) in the Decimal Separator box on the Syntax page in the Database Profile Setup dialog box.
