Complete the following steps to change the number pattern used to format currencies:
- 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.
- 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.