Changing the number pattern used to format currencies in JSP files

 Complete the following steps to change the number pattern used to format currencies: 

  1. Use the following line in a mass loadable file: 
    <curfmtdesc storeent_id="-1" setccurr="FRF"
    language_id="&en_US;" numbrusg_id="-4"
    numberpattern="#,##0.00" />
    

    where:

    storeent_id
    is the store or store group ID.
    setccurr
    is the three-character ISO 4217 currency code representing the currency you want to format. This code must appear in the SETCCURR column of the SETCURR table.
    language_id
    is the language ID of the format record.
    numbrusg_id
    is the ID of the number usage.
    numberpattern
    is the number pattern for the currency you want to format. The number pattern can contain four different characters: zero, pound sign, period, or comma. A zero (0) represents a digit, a pound sign (#) represents a digit or an absent zero as a space, a period (.) represents a placeholder for a decimal separator, or a comma (,) represents a placeholder for a grouping separator.
  2. Load the data to the WebSphere Commerce database. For instructions on how to load the data to the database, see Loading the data to the WebSphere Commerce database.