Multi-Currency Query Parameters

If your organization has enabled support for multi-currencies, accessing currency information data using data services macros requires two additional query parameters. These query parameters must be prefixed to any query intended to return multi-currency data. The parameters are:

# currency
# currency_effective_date

For example, if you run the a SQL SELECT statement calling PES_MACRO_INVESTMENT and want to return currency values in Yen, the query would be prefixed as follows:

# currency = JPY
# currency_effective_date = 1/1/2004
SELECT * FROM PES_MACRO_INVESTMENT(tmp, cls_UID = 1, Budget)

Specifying a currency value as part of running a virtual stored procedure should not cause an error if there is no currency information available. If multi-currency support is not enabled, you do not need to prefix your query with the parameters above.