The following syntax is used to generate a statement for
each exported Currency Table.
CREATE CURRENCY identifier.name
[DESC //description//]
[DECPL dec]
[PIVOT year]
[SHOW {EURO | ISO | USER}]
[ISOEDIT {Y|N}]
[RATES ( fromdate todate
[ (fromcurr ‘fromdesc' tocurr ‘todesc' rate) ]
[ (fromcurr ‘fromdesc' tocurr ‘todesc' rate) ] )]
[TYPEn ( [ (code currency) ]
[ (code currency) ] )] ;
Keywords
The
keywords correspond to values that can be specified for a Currency
Table. For more information, see Using the Currency Editor.
- CURRENCY
- Specify the name of the Currency Definition.
- identifier.name
- The two-part name of the Currency Definition name.
- DESC
- Describe the content or purpose of the Currency
Definition.
- //description//
- The 1 to 40 character description of the Currency
Definition, delimited by double slashes.
General
- DECPL
- Enter the number of decimal places for the value
when triangulation is performed.
- dec
- Specify a value between 3 and 6.
- PIVOT
- Enter the value to determine the pivot year.
- year
- The value (00 to 99) that determines the appropriate
century for two-digit years.
- SHOW
- Option to display currency codes on the Currency
Editor selection lists available from the Rates tab.
- EURO
- Show a list of all European Community currency
codes and user-defined codes on the Rates tab.
- ISO
- Show a list of all ISO and user-defined currency
codes on the Rates tab.
- USER
- Show a list of all user-defined currency codes
on the Rates tab.
- ISOEDIT
- Specify whether to permit the editing the ISO currency
descriptions on the Rates tab.
- Y
- Allow editing of ISO description.
- N
- Disallow editing of ISO description.
Rate
- RATES
- Option to specify parameters for the currency rate.
- Y
- Allow editing of ISO description.
- RATE
- Follow this keyword with parameters for the currency
rate.
- fromdate
- From date MM/DD/YYYY
- todate
- To date MM/DD/YYYY
Note: Calendar is the same as fromdate.
- fromcurr
- Source currency code (3 characters)
- ‘fromdesc'
- Source currency code description, enclosed in single
or double quotation marks.
- tocurr
- Target currency code (3 characters)
- ‘todesc'
- Target currency code description, enclosed in single
or double quotation marks.
- rate
- Conversion rate (n.n) for the
“from” and “to” currency codes.
Type
- TYPEn
- Specify up to 4 lookup tables for currency codes.
Type Table: Table 1, Table 2, Table 3, or Table 4
- code
- Code to represent a currency type as it appears
in the Type Table.
- currency
- Currency code (3 characters)