Features Added in FOCUS 7.6.4

In this section:

Starting in FOCUS 7.6.4, you can specify which currency symbol will be displayed when a format specification uses the M and N edit options.


Top of page

x
Setting a Currency Symbol for the M and N Format Options

How to:

SET CURRSYMB determines which currency symbol will be displayed when a format specification uses the M and N edit options.



x
Syntax: How to Specify a Currency Symbol
SET CURRSYMB = symbol

In a request, use

ON TABLE SET CURRSYMB symbol 

where:

symbol

Is any printable character or a supported currency code. Note: In order to specify a dollar sign as the character, you must enclose it in single quotation marks ('$'). The following are supported currency codes:

USD or '$' specifies U. S. dollars.

GBP specifies the British pound.

JPY specifies the Japanese yen.

EUR specifies the Euro.



Example: Displaying the Japanese Yen Symbol

The following request uses the EMPLOYEE data source and sets the currency symbol to the Japanese yen. Since the EMPLOYEE Master File specifies the format D12.2M for the CURR_SAL field, the yen symbol displays as the currency symbol for its field values:

TABLE FILE EMPLOYEE       
PRINT CURR_SAL            
BY LAST_NAME              
ON TABLE SET CURRSYMB JPY 
ON TABLE COLUMN-TOTAL     
END                       

The output is:

LAST_NAME               CURR_SAL
---------               --------
BANNING               ¥29,700.00
BLACKWOOD             ¥21,780.00
CROSS                 ¥27,062.00
GREENSPAN              ¥9,000.00
IRVING                ¥26,862.00
JONES                 ¥18,480.00
MCCOY                 ¥18,480.00
MCKNIGHT              ¥16,100.00
ROMANS                ¥21,120.00
SMITH                 ¥13,200.00
                       ¥9,500.00
STEVENS               ¥11,000.00
                                
TOTAL                ¥222,284.00

Information Builders