MNTCON CDN_FEXINPUT

How to:

By default, you must use a decimal point to indicate a decimal position when writing a value in a Maintain procedure (for example, a COMPUTE statement), and a comma if you wish to demarcate thousands, regardless of the CDN setting.

To write the value in a procedure using the format matching the CDN setting for a value other than OFF (for example, ON, QUOTE, QUOTEP, SPACE), use MNTCON CDN_FEXINPUT ON in the EDASPROF file or user profile, and use quotation marks to delimit the value. You can use single or double quotes when CDN=ON or SPACE. You must use double quotes when CDN=QUOTE or QUOTEP.

Example 1:

The following are both correct for all CDN settings by default:

COMPUTE MYVAL/D12.2=1234.56;
COMPUTE MYVAL/D12.2="1,234.56"; 

Example 2:

The following are both correct for SET CDN = QUOTE when the EDASPROF or user profile contains MNTCON CDN_FEXINPUT ON:

COMPUTE MYVAL/D12.2="1'234,56";
COMPUTE MYVAL/D12.2="1234,56";

Note: This command does not apply to values entered in a form at run time.

This command is outside the Maintain language, but is described in this chapter for your convenience.


Top of page

x
Syntax: How to Use the MNTCON CDN_FEXINPUT Command

When using a CDN value other than OFF, place the following statement in the server profile file (edasprof.prf) or user profile:

MNTCON CDN_FEXINPUT {ON|OFF}

where:

ON

Allows you to write values in Maintain procedures in the manner used by the actual CDN setting, for example:

  • Using a comma to denote a decimal place when CDN=ON, SPACE, or QUOTE.
  • Using a single quote to demarcate thousands when CDN=QUOTE or QUOTEP.
  • Using a space to demarcate thousands when CDN=SPACE.

Follow these rules when writing values using Continental Decimal Notation with MNTCON CDN_FEXINPUT ON:

  • You must use double or single quotes to delimit values for ON or SPACE.
  • You must use double quotes to delimit values for QUOTE. You must also use double quotes to delimit values for QUOTEP if you wish to write the value with single quotes to separate thousands.
OFF

Requires you to write values in Maintain procedures using a period to denote a decimal place for all CDN settings. OFF is the default value.

When demarcating thousands, a comma must be used, and the value must be enclosed in quotation marks.


WebFOCUS